SFA_PG_AWRD_LVL

(SQL Table)
Index Back

Pell SAS Award Level

# 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 PG_OPE_ID_NBR Character(8) VARCHAR2(8) NOT NULL OPE ID Number
9 SFA_PG_REGION_CD Character(2) VARCHAR2(2) NOT NULL Region Code
10 PG_INST_STATE Character(2) VARCHAR2(2) NOT NULL Institution State
11 PG_PAYPER_END_DT Character(8) VARCHAR2(8) NOT NULL Pay Period End Dt
12 SFA_PG_PROCESS_DT Character(8) VARCHAR2(8) NOT NULL COD Process Date
13 PG_CURRENT_SSN Character(9) VARCHAR2(9) NOT NULL Student Current SSN
14 PG_LAST_NAME Character(35) VARCHAR2(35) NOT NULL PG Last Name
15 PG_FIRST_NAME Character(35) VARCHAR2(35) NOT NULL PG First Name
16 PG_MIDLE_INITIAL Character(35) VARCHAR2(35) NOT NULL PG Middle Inital
17 SFA_NAME_SUFFIX Character(10) VARCHAR2(10) NOT NULL Student's name suffix
18 SFA_PG_AWD_FA_DT Character(8) VARCHAR2(8) NOT NULL Initial Awd Fund/Applied Date
19 PG_YTDT_DISB_AMT Number(9,2) DECIMAL(8,2) NOT NULL Year to Date Disbursement Amt
20 SFA_PG_IASG_FLAG Character(1) VARCHAR2(1) NOT NULL IASG Flag
21 PG_VERIF_STATUS Character(1) VARCHAR2(1) NOT NULL Verification Status Code
22 PG_POP_FLAG Character(1) VARCHAR2(1) NOT NULL POP Flag
23 PG_SOA_DTL_SEQ Number(6,0) INTEGER NOT NULL Pell SOA Detail Sequence Nbr