SFA_PG_HDR_DOD

(SQL Table)
Index Back

Pell SAS DOD Grant Header Rec

Pell 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