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 |