SAD_UC_ESTGRP

(SQL Table)
Index Back

cvRefEstGroup

Staging table for storing UCAS view cvRefEstGroup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAD_UC_ESTABGRP Character(3) VARCHAR2(3) NOT NULL Establishment Group Code
2 SAD_UC_ESTABTEXT Character(50) VARCHAR2(50) NOT NULL Description
3 SAD_UC_IMPORTED Character(1) VARCHAR2(1) NOT NULL Imported

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

5 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp