EMPLIDDATE_LOADEDSAD_TAC_COURSE_CDSAD_TAC_PREF_NBRSAD_TAC_PCRS_LABELSAD_TAC_CD_PCRS(SQL Table) |
Index Back |
|---|---|
TAC PreferenceThe Tertiary Admission Centre Preference Table is used as a temporary holding table for all preference details for an applicant. R-NMCPHA-2N3EF - Addition of PROGRAM_CD to allow for multiple TAC Codes to be mapped to an Academic Program R-LTAVEN-D54R6 SATAC suspense record for storing PCRS records. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATE_LOADED |
Date(10) | DATE | Date Loaded |
| 3 | SAD_TAC_COURSE_CD |
Character(10) | VARCHAR2(10) NOT NULL | TAC Course Code |
| 4 | SAD_TAC_PREF_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | TAC Preference Number |
| 5 | SAD_TAC_PCRS_LABEL |
Character(30) | VARCHAR2(30) NOT NULL | TAC Label |
| 6 | SAD_TAC_PCRS_VALUE | Character(60) | VARCHAR2(60) NOT NULL | TAC Value |
| 7 | SAD_TAC_PCRS_RSN | Character(120) | VARCHAR2(120) NOT NULL | TAC Reason |
| 8 | SAD_TAC_PCRS_BOA | Character(2) | VARCHAR2(2) NOT NULL | TAC Basis Of Admission Code |