SCC_PRSNAUS_STG(SQL Table) |
Index Back |
---|---|
Person Data - AUSAustralia-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. |