Agency-Company Employee Data Type 54

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Data Type

Max
Length

Format

BUS
Key Req?

P54

1

AIP Code

Character

2

P54
P54

2
3

Reinsurance Year
Record Type Code

Numeric
Character

4
6

P54

4

AIP Employee Key

Character

15

P54

5

Employee SSN

Character

9

Y

P54

6

Employee Type Code

Character

1

Y

P54

7

Last Name

Character

25

P54

8

First Name

Character

20

P54

9

Middle Name

Character

20

"*" = Output Only
6/27/2018

Page 1 of 8

CCYY

Delimited
2019
Approved
7/1/2018

Rules

Y

AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must equal "2019".
Record Type Code must equal "P54".
AIP Employee Key must be unique within the
submitted P54 records.
Employee SSN must be valid; edit with the SSN
table.
Employee SSN must be exactly 9 characters in
length.
Employee SSN must contain only numeric
characters.
Employee Type Code must be valid; edit with the
Employee Type ICE, "D00103".

Y

Last Name must include at least two characters.

Y

Last Name must contain alpha characters and can
include the following special characters: (-), (.), (
), ('), (,).
First Name must contain alpha characters and can
include the following special characters: (-), (.), (
), ('), (,).
Middle Name must contain alpha characters and
can include the following special characters: (-),
(.), ( ), ('), (,).

Y

Y

Y

Y
Y
Y

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Data Type

Max
Length

P54

10

Suffix

Character

10

P54

11

Title

Character

15

P54

12

Street 1 Address

Character

65

P54

13

Street 2 Address

Character

35

P54

14

City Name

Character

35

"*" = Output Only
6/27/2018

Page 2 of 8

Format

BUS
Key Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
Suffix must contain alpha characters and can
include the following special characters: (-), (.), ( ),
('), (,).
Title must contain alpha characters and can
include the following special characters: (-), (.), ( ),
('), (,).
Street 1 Address must contain alpha numeric
characters and can include the following special
characters: ( ), (-), (,), (.), ('), (&), (%), (#), (/).
Street 1 Address must be empty when
International Country Code is populated.
Street 1 Address must be populated when
International Country Code is empty.
Street 2 Address must contain alpha numeric
characters and can include the following special
characters:
( ), (-), (,), (.), ('), (&), (%), (#), (/).
Street 2 Address must be empty when
International Country Code is populated.
Street 2 Address must be populated when
International Country Code is empty.
City Name must be valid for the Zip Code and
State Abbreviation when the International
Country Code is empty, edit with the Zip Code
table.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Data Type

Max
Length

P54

15

State Abbreviation

Character

2

P54

16

Zip Code

Character

5

P54

17

Zip Extension Code

Character

4

P54

18

International Address

Character

65

"*" = Output Only
6/27/2018

Page 3 of 8

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
State Abbreviation must be valid for the Zip Code
submitted when the International Country Code is
empty; edit with the Zip Code table.
State Abbreviation must be populated when
International Country Code is empty.
State Abbreviation must be empty when
International Country Code is populated.
Zip Code must be valid for the State Abbreviation
submitted; edit with the Zip Code table.
Zip Code is required when International Country
Code is not empty.
Zip Extension Code must be valid for the Zip Code
submitted; edit with the Zip Code table,
otherwise empty.
Zip Extension Code must be empty or exactly 4
characters in length.
Zip Extension Code must be empty or exactly 4
characters in length.
International Address is required when
International Country Code is populated.
International Address must be empty when
International Country Code is empty.

Record
Number
P54

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number
19

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Field Name

Data Type

Max
Length

International Country Code

Character

2

P54

20

International Phone Country Code

P54

21

P54

Format

BUS
Key Req?

3

COI Questionnaire Completion Date

Date

8

CCYYMMDD

22

COI Questionnaire Amended Date

Date

8

CCYYMMDD

P54

23

COI Response Carryover Flag

Character

1

P54

24

COI Question 1 Response Flag

Character

1

Y

P54

25

COI Question 2 Response Flag

Character

1

Y

P54

26

COI Question 3 Response Flag

Character

1

Y

Page 4 of 8

Rules
International Country Code must be valid; edit
with International Phone Country ICE, "D00108".

Character

"*" = Output Only
6/27/2018

Delimited
2019
Approved
7/1/2018

Y

International Country Code must be empty when
State Abbreviation is populated.
International Phone Country Code must be valid;
edit with the International Phone Country Code
ICE, "D00108".
COI Questionnaire Completion Date must be
between April 1st (Reinsurance Year minus 1
year) and Batch Received Date.
COI Questionnaire Amended Date must equal the
date the COI Questionnaire was amended.
COI Questionnaire Amended Date can not be
greater than the Batch Received Date.
COI Response Carryover Flag must equal Yes, "Y"
when the response is carried forward from the
previous year, otherwise No, "N".
COI Question "1" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "2" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "3" Response Flag must equal Yes,
"Y" or No, "N".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Data Type

Max
Length

Format

BUS
Key Req?

P54

27

COI Question 4 Response Flag

Character

1

Y

P54

28

COI Question 5 Response Flag

Character

1

Y

P54

29

COI Question 6 Response Flag

Character

1

Y

P54

30

COI Question 7 Response Flag

Character

1

Y

P54

31

COI Question 8 Response Flag

Character

1

Y

P54

32

COI Question 9 Response Flag

Character

1

Y

P54

33

COI Question 10 Response Flag

Character

1

Y

P54

34

COI Question 11 Response Flag

Character

1

Y

Numeric

5

99999

Delimited
2019
Approved
7/1/2018

Rules
COI Question "4" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "5" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "6" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "7" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "8" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "9" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "10" Response Flag must equal Yes,
"Y" or No, "N".
COI Question "11" Response Flag must equal Yes,
"Y" or No, "N".
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.

P54

*

35

Initial Accepted Batch Number

P54

*

36

Initial Accepted Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Initial Accepted Date is the original date assigned
when this record was first received at RMA.

P54

*

37

Batch Received Date

Date/Time

21

CCYYMMDD
hh:mm:ss.fff

Batch Received Date is the date that the AIP file is
received by RMA.

"*" = Output Only
6/27/2018

Page 5 of 8

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

P54

*

38

P54

*

P54

*

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Data Type

Max
Length

Format

Batch Number

Numeric

5

99999

39

Batch Record ID

Numeric

15

40

Process Result Code

Character

1

"*" = Output Only
6/27/2018

Field Name

Page 6 of 8

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules
Batch Number is a sequential number assigned
when an AIP file is received.
Batch Record ID is a sequential number assigned
to each record in the AIP file by RMA during
processing. Batch Record ID is unique within the
record type for the batch.
Process Result Code equals the final result code
as determined by PASS processing, refer to the
Process Result ICE , "D00002".

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Data Type

Max
Length

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Rules

Record Level Rules
1

An Employee "P54" record, must be reported to
RMA when the Employee's COI Question 1
Response Flag = 'Y' or COI Question 2 Response
Flag = 'Y'.

2

When the Employee's COI Response Carryover
Flag = 'Y', COI Question Response Flag 1 - 11 must
contain the previous year's response.

3

An Employee "P54" data, will not appear in the
Policyholder Tracking System.
The submission of an Employee "P54" record, to
the RMA for an existing Employee, will result in a
complete replacement of current Employee "P54"
data.
An Employee "P54" record, must be accepted
before a Conflict of Interest "P51" record, will be
accepted.
The P54 record will not be processed when
processing has been suspended for this record
type per RMA directive.

4

5

6

"*" = Output Only
6/27/2018

Page 7 of 8

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:
Field
Number

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Employee
P54

Data Type

Max
Length

Rules
The P54 record must be unique in the batch for
the following business key: AIP Code,
Reinsurance Year, Employee SSN, Employee Type
Code.
The business key AIP Code, Reinsurance Year,
Employee SSN, Employee Type Code, must not
have been previously accepted for a different
record key (AIP Code, Reinsurance Year, AIP
Employee Key).

7

8

"*" = Output Only
6/27/2018

Format

BUS
Key Req?

Delimited
2019
Approved
7/1/2018

Page 8 of 8