SCC_STG_IMPAR_H

(SQL Table)
Index Back

Impairment AUS HDR Stg rec

Impairment AUS Header CTM Staging Record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
2 SCC_DISABLTY_EXIST Character(1) VARCHAR2(1) NOT NULL Existence of Disability

Y/N Table Edit

Default Value: N

3 SCC_REQUEST_SUPPRT Character(1) VARCHAR2(1) NOT NULL Request Support

Y/N Table Edit

Default Value: N

4 SCC_DISABLTY_CLAIM Character(1) VARCHAR2(1) NOT NULL DEST report field - Support Services Request
1=Support Services Claimed
2=Support Services Not Claimed

Default Value: 2

5 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
6 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
7 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
8 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time