| # |
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
|