SFA_PG_LEU_REC

(SQL Table)
Index Back

Pell LEU Staging Rec

Pell LEU Staging Record

# 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