SCC_PERSON_AUS(SQL Table) |
Index Back |
---|---|
Person Data - AUSAustralia-specific person data |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
2 | SCC_TFN | Character(9) | VARCHAR2(9) NOT NULL | This is the payee's tax file number. This is the payee's unique identification number for tax purposes. |
3 | SCC_RE_ENTER_TFN | Character(1) | VARCHAR2(1) NOT NULL | This field will be used to re-enter the payee's tax file number. |
4 | SCC_TFN_VERIFIED | Character(1) | VARCHAR2(1) NOT NULL |
This field will be used to check whether TFN is verified or not.
Y/N Table Edit Default Value: N |
5 | SCC_TFN_CERT_O_APP | Character(1) | VARCHAR2(1) NOT NULL |
TFN Certification of Application - HEIMS
Y/N Table Edit |
6 | SCC_TFN_CERT_ISSDT | Date(10) | DATE | TFN Certificate of Application issue date - HEIMS |
7 | COMMENTS | Long Character | CLOB | Comments |
8 | SCC_USI | Character(10) | VARCHAR2(10) NOT NULL | Unique Student Identifier |
9 | 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 |
10 | 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 |
11 | SCC_USI_COMMENTS | Long Character | CLOB | This field will be used to check whether USI is verified or not. |