| # |
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 |
SFA_PG_SAS_DTLSEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
Detail Sequence Number
|
| 4 |
PG_RECORD_INDIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Indicator
|
| 5 |
SFA_PG_BATCH_ID_00 |
Character(26) |
VARCHAR2(26) NOT NULL |
Pell Batch ID
|
| 6 |
PG_REPORTING_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell Reporting Campus ID
|
| 7 |
PG_ATTEND_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell Attending Campus ID
|
| 8 |
SFA_COD_ENR_SCHLCD |
Character(8) |
VARCHAR2(8) NOT NULL |
Enrollment School Code for use with the Department of Education financial aid.
|
| 9 |
PG_OPE_ID_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
OPE ID Number
|
| 10 |
SFA_PG_REGION_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Region Code
|
| 11 |
PG_INST_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Institution State
|
| 12 |
PG_PAYPER_END_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Pay Period End Dt
|
| 13 |
SFA_PG_PROCESS_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
COD Process Date
|
| 14 |
PG_CURRENT_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Student Current SSN
|
| 15 |
PG_LAST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
PG Last Name
|
| 16 |
PG_FIRST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
PG First Name
|
| 17 |
PG_MIDLE_INITIAL |
Character(35) |
VARCHAR2(35) NOT NULL |
PG Middle Inital
|
| 18 |
SFA_NAME_SUFFIX |
Character(10) |
VARCHAR2(10) NOT NULL |
Student's name suffix
|
| 19 |
SFA_PG_AWD_FA_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Initial Awd Fund/Applied Date
|
| 20 |
SFA_PG_DISB_FA_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Disbt Fund/Applied Date
|
| 21 |
PG_DISB_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Disbursement Date
|
| 22 |
SFA_PG_DISB_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Disbt Amount
|
| 23 |
SFA_PG_DSB_NET_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Disbt Actual Net Adjust
|
| 24 |
SFA_PG_DISB_NBR |
Number(5,0) |
INTEGER NOT NULL |
Disbt Nbr
|
| 25 |
SFA_PG_DISB_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Disbt Seq Nbr
|
| 26 |
SFA_PG_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
|
| 27 |
PG_YTDT_DISB_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Year to Date Disbursement Amt
|
| 28 |
SFA_PG_IASG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
IASG Flag
|
| 29 |
PG_VERIF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Status Code
|
| 30 |
PG_POP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
POP Flag
|
| 31 |
SFA_PG_SYSGENARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generated Indicator
|
| 32 |
PG_SOA_DTL_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Pell SOA Detail Sequence Nbr
|