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 |