SFA_PG_HDR_DOD(SQL Table) |
Index Back |
|---|---|
Pell SAS DOD Grant Header RecPell SAS DOD Grant Header Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Date(10) | DATE | PELL SAS Run Date | |
| 2 | Number(9,0) | DECIMAL(9) NOT NULL | PELL SAS - Sequence Number | |
| 3 | PG_HEADER_ID | Character(10) | VARCHAR2(10) NOT NULL | Pell Header ID |
| 4 | PG_RECORD_LENGTH | Character(4) | VARCHAR2(4) NOT NULL | Pell Record Length |
| 5 | SFA_PG_BATCH_ID_00 | Character(26) | VARCHAR2(26) NOT NULL | Pell Batch ID |
| 6 | PG_OPE_ID_NBR | Character(8) | VARCHAR2(8) NOT NULL | OPE ID Number |
| 7 | PG_SOFTWARE_ID | Character(10) | VARCHAR2(10) NOT NULL | Software Provider ID |
| 8 | PG_FILLER_10 | Character(10) | VARCHAR2(10) NOT NULL | Filler 10 |
| 9 | PG_RFMS_PROC_DT | Character(8) | VARCHAR2(8) NOT NULL | Pell RFMS Process Dt |
| 10 | PG_BATCH_RJCT_1 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 1 |
| 11 | PG_BATCH_RJCT_2 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 2 |
| 12 | PG_BATCH_RJCT_3 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 3 |
| 13 | PG_BATCH_RJCT_4 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 4 |
| 14 | PG_BATCH_RJCT_5 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 5 |
| 15 | PG_BATCH_RJCT_6 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 6 |
| 16 | PG_BATCH_RJCT_7 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 7 |
| 17 | PG_BATCH_RJCT_8 | Character(3) | VARCHAR2(3) NOT NULL | Pell Batch Reject 8 |
| 18 | PELL_TRANS_DTTM | DateTime(26) | TIMESTAMP | Pell Trans Date/Time |
| 19 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 20 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 21 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Aid Year |