SFA_PG_AWRD_LVL(SQL Table) | 
Index Back | 
|---|---|
Pell SAS Award Level | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Date(10) | DATE | PELL SAS Run Date | |
| 2 | Number(9,0) | DECIMAL(9) NOT NULL | PELL SAS - Sequence Number | |
| 3 | 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 |