SAD_UC_APR

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 SAD_UC_DOM Character(3) VARCHAR2(3) NOT NULL Domicile
3 SAD_UC_DOMTEXT Character(250) VARCHAR2(250) NOT NULL Description
4 SAD_UC_LEAFLAG Character(1) VARCHAR2(1) NOT NULL LEA Flag

Y/N Table Edit

5 SAD_UC_HESACODE Character(3) VARCHAR2(3) NOT NULL Equivalent HESA Country Code
6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

7 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

8 SAD_UC_IMPORTED Character(1) VARCHAR2(1) NOT NULL Imported

Y/N Table Edit

Default Value: N

9 SAD_UC_ACTIVE_IND Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

Default Value: Y

10 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp