Here are the required fields for the state location table.
Field |
Type |
Length |
Notes |
Form |
Char |
36 |
|
State |
Char |
8 |
|
PolicyEffectiveDate |
Char |
10 |
CCYY-MM-DD |
PolicyWrittenDate |
Char |
10 |
CCYY-MM-DD |
ControllingState |
Char |
2 |
|
Location |
Char |
8 |
|
SubLocation |
Char |
8 |
|
LocationAddrDate |
Char |
10 |
CCYY-MM-DD |
TransactionEffectiveDate |
Char |
10 |
CCYY-MM-DD |
ProgramCd |
Char |
6 |
|
Here are the required fields for the FED table.
Field |
Type |
Length |
Notes |
FormNumber |
Char |
36 |
|
FormProcessingType |
Char |
1 |
|
EffectiveDateSourceCD |
Char |
2 |
“PE” or “PW” |
EffectiveDate |
Char |
10 |
CCYY-MM-DD |
WithdrawalDate |
Char |
10 |
CCYY-MM-DD |
© Copyright 2012, Oracle and/or its affiliates. All rights reserved. Legal notices.