SAD_AP_SUS_AWRD(SQL Table) |
Index Back |
|---|---|
AP Suspense Award InformationThis contains all the Award information from prior years. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: SA_TEST_TBL |
|
| 2 | Number(9,0) | DECIMAL(9) NOT NULL |
Test Type Record Nbr
Prompt Table: SAD_AP_SUS |
|
| 3 | Number(2,0) | SMALLINT NOT NULL | Award Number | |
| 4 | AWARD_TYPE_AP | Character(2) | VARCHAR2(2) NOT NULL | AP Award Type |
| 5 | AWARD_YR_AP | Character(2) | VARCHAR2(2) NOT NULL | AP Award Year |