PG_YTDORG_00_EC

(SQL Table)
Index Back

Pell YTD Orignatn Staging Tbl

For 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