SAD_TAC_CD_PRF(SQL Table) |
Index Back |
|---|---|
TAC Preference |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 2 | Date(10) | DATE | Date Loaded | |
| 3 | Character(10) | VARCHAR2(10) NOT NULL | TAC Course Code | |
| 4 | Number(9,0) | DECIMAL(9) NOT NULL | TAC Preference Number | |
| 5 | SAD_TAC_PLAN | Character(10) | VARCHAR2(10) NOT NULL | TAC Plan |
| 6 | COURSE_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 7 | SAD_TAC_STREAM_CD | Character(10) | VARCHAR2(10) NOT NULL | TAC Stream Code for SATAC |
| 8 | SAD_TAC_STREAM_TTL | Character(50) | VARCHAR2(50) NOT NULL | TAC Stream Title |
| 9 | SAD_TAC_OFFR_ROUND | Number(5,0) | INTEGER NOT NULL | TAC offer Round Number |
| 10 | OFFER_DT | Date(10) | DATE | Offer Date |
| 11 | SAD_TAC_OFFER_RSP | Character(2) | VARCHAR2(2) NOT NULL | TAC Offer Response |
| 12 | SAD_TAC_PRF_CAS_TP | Character(3) | VARCHAR2(3) NOT NULL | TAC Preference Type |
| 13 | SAD_TAC_PRF_CAS_VL | Character(30) | VARCHAR2(30) NOT NULL | TAC Preference Value |
| 14 | SAD_TAC_PRF_CAS_RS | Character(120) | VARCHAR2(120) NOT NULL | TAC Preference Reason |
| 15 | SAD_TAC_PRF_OFF_BS | Character(120) | VARCHAR2(120) NOT NULL | TAC Pref Offer Basis |
| 16 | SAD_TAC_PREF_ADM | Character(2) | VARCHAR2(2) NOT NULL | TAC Admission Preference |
| 17 | SAD_TAC_PREF_DT | Date(10) | DATE | TAC Preference Date |
| 18 | SAD_TAC_OFF_ST_NBR | Character(1) | VARCHAR2(1) NOT NULL | TAC Offer Stream Number |
| 19 | SAD_TAC_RANK_POS | Character(5) | VARCHAR2(5) NOT NULL | TAC Rank Position |
| 20 | SAD_TAC_SYSTEM_RNK | Character(4) | VARCHAR2(4) NOT NULL | TAC System Rank |
| 21 | SAD_TAC_OFFER_STAT | Character(1) | VARCHAR2(1) NOT NULL | TAC Offer Status |
| 22 | SAD_TAC_SPEC_ADM | Character(2) | VARCHAR2(2) NOT NULL | TAC Spec. Admission |
| 23 | SAD_TAC_METHOD_A | Character(3) | VARCHAR2(3) NOT NULL | TAC Method A |
| 24 | SAD_TAC_METHOD_B | Character(3) | VARCHAR2(3) NOT NULL | TAC Method B |
| 25 | SAD_TAC_ALT_METHOD | Character(3) | VARCHAR2(3) NOT NULL | TAC Alt Method |
| 26 | SAD_TAC_OFF_METH_A | Character(3) | VARCHAR2(3) NOT NULL | TAC Offer Method A |
| 27 | SAD_TAC_OFF_METH_B | Character(3) | VARCHAR2(3) NOT NULL | TAC Offer Method B |
| 28 | SAD_TAC_PROGRAM_CD | Character(10) | VARCHAR2(10) NOT NULL | Program Code |