CONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
PERIODSEQ_NUMGM_AWDMODSEQ_VW(SQL View) |
Index Back |
|---|---|
Award Funding by Period/Seq |
| SELECT CONTRACT_NUM , PERIOD , SEQ_NUM , BEGIN_DT , END_DT , REF_AWD_NUMBER , ISSUE_DT FROM PS_GM_AWD_MOD_LINE |
| # | 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 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 5 | END_DT | Date(10) | DATE NOT NULL | End Date |
| 6 | REF_AWD_NUMBER | Character(25) | VARCHAR2(25) NOT NULL | Reference Award Number |
| 7 | ISSUE_DT | Date(10) | DATE | Issue Dt |