| # |
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_ORIG_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Original SSN
|
| 5 |
PG_NAME_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Original Name Code
|
| 6 |
PG_TRANSACTION_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Transaction Number
|
| 7 |
SFA_PG_CPS_PRCS_DT |
Date(10) |
DATE |
Pell CPS Prcs Date
|
| 8 |
SFA_PG_FPS_PRCS_DT |
Date(10) |
DATE |
Pell FPS Prcs Date
|
| 9 |
SFA_PG_SAI |
Character(6) |
VARCHAR2(6) NOT NULL |
Student Aid Index (SAI)
|
| 10 |
PELL_EFC |
Number(6,0) |
INTEGER NOT NULL |
Pell EFC
|
| 11 |
PG_LAST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
PG Last Name
|
| 12 |
SFA_NAME_SUFFIX |
Character(10) |
VARCHAR2(10) NOT NULL |
Student's name suffix
|
| 13 |
PG_FIRST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
PG First Name
|
| 14 |
SFA_PG_MIDDLE_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
Middle Name
|
| 15 |
PG_DATE_OF_BIRTH_O |
Date(10) |
DATE |
Pell Student Date of Birth
|
| 16 |
PG_CURRENT_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Student Current SSN
|
| 17 |
PG_LIFETM_EU |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Lifetime Eligibility Used
|
| 18 |
PG_FAA_EMAIL |
Character(50) |
VARCHAR2(50) NOT NULL |
FAA Email Address
|
| 19 |
PG_REPORTING_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell Reporting Campus ID
|