Records Producer Certification Record Type 75

Record
Number

Output

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

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Producer Certification
P75

Data Type

Max
Length

Format

BUS
Key

Req?

Rules

Y
Y
Y

AIP Code must be valid; edit with the AIP ICE, "D00100".
Reinsurance Year must equal "2019".
Record Type Code must equal "P75".
AIP Producer Certification Key must be unique within the
submitted Producer Certification, "P75" record.
Tax ID must be a valid SSN when the Tax ID Type Code equals
SSN "1", edit with SSN Table.
Tax ID Type Code must be valid; edit with the
Tax ID Type Code ICE, "D00005".
Tax ID Type Code must not equal EIN "2".

P75
P75
P75

1
2
3

AIP Code
Reinsurance Year
Record Type Code

Character
Numeric
Character

2
4
6

P75

4

AIP Producer Certification Key

Character

15

Y

Y

P75

5

Tax ID

Character

9

Y

Y

P75

6

Tax ID Type Code

Character

1

Y

Y

P75

7

Certification Signature Date

Date

8

CCYYMMDD

Y

Y

P75

8

Cancellation Date

Date

8

CCYYMMDD

P75

9

Last Name

Character

25

Y

P75

10

First Name

Character

20

Y

P75

11

Middle Name

Character

20

P75

12

Suffix

Character

10

P75

13

Title

Character

15

P75

14

Street 1 Address

Character

65

"*" = Output Only

CCYY

Page 1 of 3

Delimited
2019
Approved
7/1/2018

Certification Signature Date must be the date of the insured's
signature on the Beginning Farmer Rancher Application.
Cancellation date must be greater than or equal to the
Certification Signature Date.
Last Name must contain only alpha characters and can
include the following special characters: (-), (.), ( ), ('), (,).
First Name must contain only alpha characters and can
include the following special characters: (-), (.), ( ), ('), (,).
Middle Name must contain only alpha characters and can
include the following special characters: (-), (.), ( ), ('), (,).
Suffix must contain only alpha characters and can include the
following special characters: (-), (.), ( ), ('), (,).
Title must contain only alpha characters and can include the
following special characters: (-), (.), ( ), ('), (,).
Street 1 Address must be empty when International Country
Code exists.
Street 1 Address must contain only alpha numeric characters
and can include the following special characters: (-), (.), ( ), ('),
(,), (&), (%), (#), (/).

Record
Number

Output

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

Field Name

Producer Certification
P75

Data Type

Max
Length

P75

15

Street 2 Address

Character

35

P75

16

City Name

Character

35

P75

17

State Abbreviation

Character

2

P75

18

Zip Code

Character

5

P75

19

Zip Code Extension

Character

4

P75

20

International Address

Character

65

P75

21

International Country Code

Character

2

22

Initial Accepted Batch Number

Numeric

5

P75

*

"*" = Output Only

File Type:
Reinsurance Year:
Version:
Release Date:

Format

BUS
Key

Req?

Y

Delimited
2019
Approved
7/1/2018

Rules
City Name must contain only alpha numeric characters and
can include the following special characters: ( ), (-), (,), (.), (').
City Name must be valid; edit with the Zip table when
International Country Code is empty.
State Abbreviation is Required when International Country
Code is empty.
State Abbreviation must be valid; edit with the Zip table.
Zip Code is Required when State Abbreviation exists.
Zip Code must be valid; edit with the Zip table.
Zip Code Extension must be exactly four characters in length,
otherwise empty.
International Address is required when State Abbreviation is
empty.
International Address must contain only alphanumeric
characters and can include the following special characters: (
), (-), (,), (.), ('), (&), (%), (#), (/) when State Abbreviation is
empty.
International Address must be empty when State
Abbreviation exists.
International Country Code is required when State
Abbreviation is empty.
International Country Code must be empty when State
Abbreviation is populated.
International County Code must be valid, edit with the
International Phone Country ICE, "D00108".

99999

Page 2 of 3

Initial Accepted Batch Number is the original sequence
number assigned when this record was first received at RMA.

Record
Number

Output

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

P75

*

23

P75

*

P75

Producer Certification
P75

Data Type

Max
Length

Initial Accepted Date

Date/Time

21

24

Batch Received Date

Date/Time

21

*

25

Batch Number

Numeric

5

P75

*

26

Batch Record ID

Numeric

15

P75

*

27

Process Result Code

Character

1

Field Name

File Type:
Reinsurance Year:
Version:
Release Date:

Format
CCYYMMDD
hh:mm:ss.fff
CCYYMMDD
hh:mm:ss.fff
99999

BUS
Key

Req?

Delimited
2019
Approved
7/1/2018

Rules
Initial Accepted Date is the original date assigned when this
record was first received at RMA.
Batch Received Date is the date that the AIP file is received by
RMA.
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 Level Rules
A Producer Certification, "P75" record already exists for this
Tax ID/Tax ID Type Code combination for another
Reinsurance Year.  You must update your currently accepted
P75/P75A instead of creating a new P75/P75A for a different
Reinsurance Year.

1

"*" = Output Only

Page 3 of 3