SCC_PRSNAUS_STG

(SQL Table)
Index Back

Person Data - AUS

Australia-specific person data

# 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_USI Character(10) VARCHAR2(10) NOT NULL Unique Student Identifier
3 SCC_USI_VERIFIED Character(1) VARCHAR2(1) NOT NULL This field will be used to check whether USI is verified or not.

Y/N Table Edit

Default Value: N

4 SCC_USI_EXEMP Character(1) VARCHAR2(1) NOT NULL This field will be used to check whether USI is verified or not.

Y/N Table Edit

Default Value: N

5 SCC_USI_COMMENTS Long Character CLOB This field will be used to check whether USI is verified or not.