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 | SFA_PG_SAS_RUN_DT | Date(10) | DATE | PELL SAS Run Date |
2 | SFA_PG_SAS_SEQ_NBR | 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 |