CONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
PERIODGM_AWDMOD_PD_VW(SQL View) |
Index Back |
|---|---|
Award Funding by Period |
| SELECT CONTRACT_NUM , PERIOD , BEGIN_DT , END_DT , ISSUE_DT , REF_AWD_NUMBER FROM PS_GM_AWD_MOD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Award ID
Prompt Table: CA_CNTR_SRCH_VW |
| 2 | PERIOD |
Number(3,0) | SMALLINT NOT NULL | Period |
| 3 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 4 | END_DT | Date(10) | DATE NOT NULL | End Date |
| 5 | ISSUE_DT | Date(10) | DATE | Issue Dt |
| 6 | REF_AWD_NUMBER | Character(25) | VARCHAR2(25) NOT NULL | Reference Award Number |