PG_YTDORG_00_EC(SQL Table) |
Index Back |
---|---|
Pell YTD Orignatn Staging TblFor 1999-2000 Pell Processing. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ECTRANSID | Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
2 | ECQUEUEINSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
3 | ECTRANSINOUTSW | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound Default Value: I |
4 | PG_ORIGINATION_ID | Character(23) | VARCHAR2(23) NOT NULL | Pell Origination ID |
5 | PG_ORIG_SSN | Character(9) | VARCHAR2(9) NOT NULL | Original SSN |
6 | PG_NAME_CODE | Character(2) | VARCHAR2(2) NOT NULL | Original Name Code |
7 | PG_ATTEND_ID | Character(6) | VARCHAR2(6) NOT NULL | Pell Attending Campus ID |
8 | PELL_ORIG_SEQ_NBR | Number(2,0) | SMALLINT NOT NULL | Pell Origination Sequence Nbr |
9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
10 | PG_ACTION_CODE | Character(1) | VARCHAR2(1) NOT NULL | Action Code |
11 | PELL_PAY_PERIODS | Number(1,0) | SMALLINT NOT NULL | Pell Payment Periods |
12 | PELL_AWARD_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | Total Pell Award Amount |
13 | PG_EST_DSB_DT_1_O | Date(10) | DATE | Estimated Dsibursement Date 1 |
14 | PG_EST_DSB_DT_2_O | Date(10) | DATE | Estimated Dsibursement Date 2 |
15 | PG_EST_DSB_DT_3_O | Date(10) | DATE | Estimated Dsibursement Date 3 |
16 | PG_EST_DSB_DT_4_O | Date(10) | DATE | Estimated Dsibursement Date 4 |
17 | PG_EST_DSB_DT_5_O | Date(10) | DATE | Estimated Dsibursement Date 5 |
18 | PG_EST_DSB_DT_6_O | Date(10) | DATE | Estimated Dsibursement Date 6 |
19 | PG_EST_DSB_DT_7_O | Date(10) | DATE | Estimated Dsibursement Date 7 |
20 | PG_EST_DSB_DT_8_O | Date(10) | DATE | Estimated Dsibursement Date 8 |
21 | PG_EST_DSB_DT_9_O | Date(10) | DATE | Estimated Dsibursement Date 9 |
22 | PG_EST_DSB_DT_10_O | Date(10) | DATE | Estimated Dsibursement Date 10 |
23 | PG_EST_DSB_DT_11_O | Date(10) | DATE | Estimated Dsibursement Date 11 |
24 | PG_EST_DSB_DT_12_O | Date(10) | DATE | Estimated Dsibursement Date 12 |
25 | PG_EST_DSB_DT_13_O | Date(10) | DATE | Estimated Dsibursement Date 13 |
26 | PG_EST_DSB_DT_14_O | Date(10) | DATE | Estimated Dsibursement Date 14 |
27 | PG_EST_DSB_DT_15_O | Date(10) | DATE | Estimated Dsibursement Date 15 |
28 | PELL_ENRLMNT_DT | Date(10) | DATE | Pell Enrollment Date |
29 | LOW_TUITION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Low Tuition and Fees Flag
1=Tuition is 0 2=Low Tuition Range 2 3=Low Tuition Range 3 4=Low Tuition Range 4 |
30 | VERIF_STATUS_CODE | Character(1) | VARCHAR2(1) NOT NULL |
ED Verification Status Cd
A=Accurate Data B=Blank C=Calculated N=Not Selected R=Reprocessed S=Selected, Not Verified T=Tolerance V=Verified W=Without Documentation |
31 | PG_INCARCERATED_CD | Character(1) | VARCHAR2(1) NOT NULL | Incarcerated Code |
32 | ISIR_TXN_NBR | Number(2,0) | SMALLINT NOT NULL | Transaction Num |
33 | PELL_EFC | Number(6,0) | INTEGER NOT NULL | Pell EFC |
34 | SECONDARY_EFC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Secondary EFC Flag
O=Orig'l EFC now used for Pell S=Secondary EFC used for Pell |
35 | ACADEMIC_CALENDAR | Character(1) | VARCHAR2(1) NOT NULL |
Academic Calendar
1=Credit Hr (non-standard terms) 2=Use standard quarters 3=Use standard semesters 4=Use standard trimesters 5=Academic progress by clock-hrs 6=Credit Hr w/o Terms |
36 | PELL_PMT_METH | Character(1) | VARCHAR2(1) NOT NULL |
Payment Methodology
1=Formula 1 2=Formula 2 3=Formula 3 4=Formula 4 5=Formula 5 6=Other |
37 | PELL_BDGT_COA | Number(9,2) | DECIMAL(8,2) NOT NULL | Pell COA |
38 | PG_ENROLLMENT_STAT | Character(1) | VARCHAR2(1) NOT NULL | Enrollment Status |
39 | PG_WEEKS_USED_CALC | Character(2) | VARCHAR2(2) NOT NULL | Weeks Used in Calculation |
40 | PG_WEEKS_ACAD_YEAR | Character(2) | VARCHAR2(2) NOT NULL | Weeks in Prgm Acad Year |
41 | PG_HOURS_PAY_PER | Character(4) | VARCHAR2(4) NOT NULL | Hours used in Payment Period |
42 | PG_HOURS_ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Hours in Academic Year |
43 | PELL_SCHED_AWARD | Number(5,0) | INTEGER NOT NULL | Scheduled Pell Award |
44 | PG_STUDENT_NAME | Character(29) | VARCHAR2(29) NOT NULL | Pell Student Name |
45 | PG_CURRENT_SSN | Character(9) | VARCHAR2(9) NOT NULL | Student Current SSN |
46 | PG_DATE_OF_BIRTH_O | Date(10) | DATE | Pell Student Date of Birth |
47 | PG_CPS_VERF_SEL_CD | Character(1) | VARCHAR2(1) NOT NULL | CPS Verification Selection Cd |
48 | PG_YTD_DISB_AMOUNT | Character(7) | VARCHAR2(7) NOT NULL | YTD Disbursed Amount |
49 | PG_BATCH_ID_00 | Character(26) | VARCHAR2(26) NOT NULL | Pell Batch ID |
50 | PG_RFMS_PROC_DT_O | Date(10) | DATE | Pell RFMS Process Dt |
51 | PG_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | PG Last Name |
52 | PG_FIRST_NAME | Character(35) | VARCHAR2(35) NOT NULL | PG First Name |
53 | PG_MIDLE_INITIAL | Character(35) | VARCHAR2(35) NOT NULL | PG Middle Inital |
54 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
55 | PG_STG_PROC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Pell Staging Rec Proc Status
E=Error N=Not Processed P=Processed Default Value: N |
56 | PELL_TRANS_DTTM | DateTime(26) | TIMESTAMP | Pell Trans Date/Time |
57 | SFA_COD_ADDTN_ELIG | Character(1) | VARCHAR2(1) NOT NULL | Additional Elig Indicator |
58 | SFA_COD_DECSD_VET | Character(1) | VARCHAR2(1) NOT NULL | Post 9/11 Dependent |
59 | SFA_ATB_CD | Character(2) | VARCHAR2(2) NOT NULL |
Ability To Benefit Code
01=01: Complete before 7/1/2012 02=02: College before 7/1/2012 03=03: State Process 04=04: Home Schooled 05=05: Other 06=06: High School Diploma 07=07: General Ed Development 08=08: State-Authorized exam/cert 09=09: Acad Transc min 2 YR Prog 10=10: Excelled in High School 11=11: Complete 7/1/12 - 6/30/15 12=12: Complete after 7/1/2012 13=13: College 7/1/12 - 6/30/15 14=14: College after 7/1/2012 15=15: CPT Program |
60 | SFA_ATB_TST_ADM_CD | Character(2) | VARCHAR2(2) NOT NULL |
Ability to Benefit Test Adminitrator Code
01=01: Testing Center 02=02: Test Administrator |
61 | SFA_ATB_TST_CD | Character(2) | VARCHAR2(2) NOT NULL |
Ability To Benefit Test Code
01=01: ASSET Program 02=02: Career Program Assessment 03=03: COMBO English Lang Skills 04=04: Compass Subtests 05=05: COMP Placement Tests 06=06: Descriptive LANG Skills 07=07: ESL Placement Test 08=08: Wonderic Basic Skills Test 09=09: WorkKeys Program 10=10: Test of Adult Basic ED 11=11: Spanish Assessment 12=12: WBST - Spanish 13=13: TSI Assessment |
62 | SFA_ATB_COMP_DT | Date(10) | DATE | Ability to Benefit Completion Date |
63 | SFA_ATB_STATE_CD | Character(2) | VARCHAR2(2) NOT NULL | Ability to Benefit State Code |
64 | SFA_PELL_CFH_IND | Character(1) | VARCHAR2(1) NOT NULL | PELL CFH Indicator |
65 | SFA_PG_SAI | Character(6) | VARCHAR2(6) NOT NULL | Student Aid Index (SAI) |
66 | SFA_NAME_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | Student's name suffix |
67 | SFA_PG_IAS_GRANT | Character(1) | VARCHAR2(1) NOT NULL | IAS Grant |
68 | SFA_FPS_VRF_SEL_CD | Character(1) | VARCHAR2(1) NOT NULL | FPS Verification Selection code |