|
# |
Column Name |
Type |
Description |
|
A 1 |
#*REVENUE_KEY |
C 20 |
Revenue Source or Obligor unique identifier |
|
A 2 |
REVENUE_NAME1 |
C 50 |
Revenue Source or Obligor full description 1 |
|
A 3 |
REVENUE_NAME2 |
C 50 |
Revenue Source or Obligor full description 2 |
|
A 4 |
REVENUE_NAME3 |
C 50 |
Revenue Source or Obligor full description 3 |
|
A 5 |
SP_RATING |
Alpha |
Standard & Poor's evaluation of the obligor's credit risk (S&P) |
|
A 6 |
SP_SHADOW_INDICATOR |
C 1 |
Is the assigned S&P rating published? Y or N |
|
A 7 |
SP_RATING_DATE |
Date |
Date of most current S&P rating |
|
A 8 |
NAIC_ID |
C 8 |
NAIC code/ID |
|
A 9 |
MOODY_RATING |
Alpha |
Moody's evaluation of the obligor's credit risk |
|
A 10 |
MOODY_SHADOW_INDICAT OR |
C 1 |
Is the assigned Moody's rating published? Y or N |
|
A 11 |
MOODY_RATING_DATE |
Date |
Date of most current Moody's rating |
|
A 12 |
INT_RATING |
C 10 |
Primary insurer's evaluation of the obligor's credit risk |
|
A 13 |
SP_SECTOR_CODE |
Alpha |
Standard & Poor's sector code |
|
A 14 |
SP_SECTOR_CATEGORY |
Alpha |
Standard & Poor's sector category |
|
A 15 |
SP_SINGLE_RISK_CATEGO RY |
Alpha |
Standard & Poor's single risk category |
|
A 16 |
COUNTRY_ISO |
Alpha |
The country in which the obligor is located If unknown, presume it is domestic and fill with the code for USA. |
|
A 17 |
STATE |
Alpha |
The state in which the obligor is located For Foreign countries, the following are acceptable: (a) Designation of an "Unknown" state (e.g. "Other") (b) State = Country (c) State is a valid province or state in that country In any case, the values should be in the Codes table. |
|
A 18 |
COUNTY |
C 50 |
The county in which the obligor is located, if known. |
|
A 19 |
BLANK_01 |
C 15 |
Blank Field (Reserved) |
|
A 20 |
BLANK_02 |
C 15 |
Blank Field (Reserved) |
|
A 21 |
BLANK_03 |
C 15 |
Blank Field (Reserved) |
