SCC_HRCS_SPLT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 2 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 3 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 4 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 7 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 8 | NAME_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Name Title |
| 9 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 10 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 11 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 12 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 13 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 14 | NAME_FORMAL | Character(60) | VARCHAR2(60) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 15 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 16 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 17 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 18 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 19 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 20 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 21 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 22 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 23 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 24 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 25 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 26 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 27 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Type
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
| 28 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 29 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 30 | SSN_KEY_FRA | Character(2) | VARCHAR2(2) NOT NULL | Social Security Number Key |
| 31 | TAX_REF_ID_SGP | Character(1) | VARCHAR2(1) NOT NULL | Tax Reference Id - Singapore |
| 32 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 33 | DT_OF_DEATH | Date(10) | DATE | Date of Death |
| 34 | MARITAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Marital Status Flag |
| 35 | DRIVERS_LIC_NBR | Character(20) | VARCHAR2(20) NOT NULL | Driver's License Nbr |
| 36 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
| 37 | EXTERNAL_SYSTEM | Character(3) | VARCHAR2(3) NOT NULL | External System |
| 38 | EXTERNAL_SYSTEM_ID | Character(20) | VARCHAR2(20) NOT NULL | External System ID |
| 39 | CNST_TYPE | Number(3,0) | SMALLINT NOT NULL | Constituent Type |
| 40 | SCC_NSN | Number(10,0) | DECIMAL(10) NOT NULL | National Student Number (NZL) |
| 41 | SSR_CORRSPN_NR_NLD | Character(12) | VARCHAR2(12) NOT NULL | Correspondance Number IBG |
| 42 | ETHNIC_GRP_CD | Character(8) | VARCHAR2(8) NOT NULL | Ethnic group code |
| 43 | AV_CLASS_YR | Number(4,0) | SMALLINT NOT NULL | Class Year |
| 44 | SCC_CHESSN | Character(10) | VARCHAR2(10) NOT NULL | Commonwealth Higher Education Student Support Number (CHESSN) |