Field Name | Format | Source/Value/Description |
SP_ID | A10 | CI_FA |
SP_DESCR | A254 | CI_SP.DESCR254 |
SP_TYPE_CD | A8 | CI_SP |
SP_TYPE_DESCR | A60 | CI_SP_TYPE_L.DESCR |
SP_SUBTYPE_FLG | A2 | CI_SP_TYPE |
SP_SUBTYPE_DESCR | A60 | CI_LOOKUP/SP Subtype Flag |
SP_STATUS_FLG | A2 | CI_SP |
INSTALL_DT | Date | CI_SP |
SP_SRC_STATUS_FLG | A2 | CI_SP |
DISCON_LOC_CD | A4 | CI_SP |
DISCON_LOC_DESCR | A60 | CI_DISCON_LOC_L |
MR_CYC_CD | A4 | CI_SP |
MR_CYC_DESCR | A60 | CI_MR_CYC_L |
MTR_LOC_CD | A4 | CI_SP |
MTR_LOC_DESCR | A60 | CI_MTR_LOC_L |
MTR_LOC_DETAILS | A250 | CI_SP |
FAC_LVL_1_CD | A8 | CI_SP |
FAC_LVL_1_DESCR | A60 | CI_FAC_LVL_1_L.DESCR |
FAC_LVL_2_CD | A8 | CI_SP |
FAC_LVL_2_DESCR | A60 | CI_FAC_LVL_3_L.DESCR |
FAC_LVL_3_CD | A8 | CI_SP |
FAC_LVL_3_DESCR | A60 | CI_FAC_LVL_3_L.DESCR |