PROCESS_INSTANCESAD_COUNTERSAD_ADA_TMP(SQL Table) |
Index Back |
|---|---|
ADA Suspn Temp TableThis record is used to read in the course file. The data is stored here temporarily until the correct Test Rec Number can be identified. The data is then moved to SAD_ADA_SUS_CS and SAD_ADA_SUS_CD. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SAD_COUNTER |
Number(5,0) | INTEGER NOT NULL | Counter |
| 3 | AADSAS_ID_NBR | Character(11) | VARCHAR2(11) NOT NULL | Applicant Id |
| 4 | CRSE_SESSN_NBR | Number(2,0) | SMALLINT NOT NULL | Course Number |
| 5 | SESSN_STATS_AADSAS | Character(30) | VARCHAR2(30) NOT NULL | AADSAS Session Status |
| 6 | COLG_CODE_AADSAS | Character(6) | VARCHAR2(6) NOT NULL | College Code |
| 7 | FROM_DT_AADSAS | Character(6) | VARCHAR2(6) NOT NULL | AADSAS Begin Date |
| 8 | TO_DT_AADSAS | Character(6) | VARCHAR2(6) NOT NULL | AADSAS End Date |
| 9 | TERM_TYPE_AADSAS | Character(10) | VARCHAR2(10) NOT NULL | AADSAS Term Type |
| 10 | CRSE_NBR | Number(2,0) | SMALLINT NOT NULL | Course Number |
| 11 | CRSE_CODE_AADSAS | Character(4) | VARCHAR2(4) NOT NULL | AADSAS Course Code |
| 12 | CRSE_TYPE_AADSAS | Character(1) | VARCHAR2(1) NOT NULL | AADSAS Course Type |
| 13 | CRSE_GPA_AADSAS | Character(2) | VARCHAR2(2) NOT NULL | AADSAS GPA |
| 14 | CRSE_HRS_AADSAS | Character(3) | VARCHAR2(3) NOT NULL | AADSAS Hours |
| 15 | TEST_REC_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Test Type Record Nbr |