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 | TEST_ID | Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: SA_TEST_TBL |
2 | TEST_REC_NBR | Number(9,0) | DECIMAL(9) NOT NULL |
Test Type Record Nbr
Prompt Table: SAD_AP_SUS |
3 | AWARD_INFO_NBR | 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 |