PELL_ORIG_DTL

(SQL Table)
 Index Back

Pell Origination Record

  • Parent record: PELL_ORIGINATN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: STUDENT_AID

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: AID_YEAR_TBL

    4 PELL_ORIG_ID Character(23) VARCHAR2(23) NOT NULL Pell Origination ID
    5 PELL_ORIG_SEQ_NBR Number(2,0) SMALLINT NOT NULL Pell Origination Sequence Nbr
    6 ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
    7 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
    8 ISIR_TXN_NBR Number(2,0) SMALLINT NOT NULL Transaction Num
    9 PELL_EFC Number(6,0) INTEGER NOT NULL Pell EFC
    10 PELL_ID_ATTENDED Character(6) VARCHAR2(6) NOT NULL Attended Pell ID

    Prompt Table: INST_CPS_SRCH

    11 PELL_BDGT_COA Number(9,2) DECIMAL(8,2) NOT NULL Pell COA
    12 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
    13 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
    14 PELL_ENROLL_STAT Character(1) VARCHAR2(1) NOT NULL Pell Enrollment Status
    15 HOURS_CRD_PD Character(4) VARCHAR2(4) NOT NULL Hours Credits Paid
    16 HRS_CREDITS_ACADYR Character(4) VARCHAR2(4) NOT NULL Hours Credits in Acad Yr
    17 PELL_AWARD_AMT Number(8,2) DECIMAL(7,2) NOT NULL Total Pell Award Amount
    18 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
    19 PELL_PAY_PERIODS Number(1,0) SMALLINT NOT NULL Pell Payment Periods
    20 INCARCERATED_CODE Character(1) VARCHAR2(1) NOT NULL Incarcerated Code
    N=No longer incarcerated
    Y=Incarcerated
    21 PELL_ENRLMNT_DT Date(10) DATE Pell Enrollment Date
    22 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    23 ACTION_CODE Character(1) VARCHAR2(1) NOT NULL Action Code
    A=Accepted
    C=Corrected
    D=Duplicate
    E=Rejected
    N=Not Processed, in Rejected Doc
    24 WEEKS_USED_TO_CALC Character(2) VARCHAR2(2) NOT NULL Weeks Used to Calculate
    25 WEEKS_PROG_ACADYR Character(2) VARCHAR2(2) NOT NULL Weeks in Program Acad Year
    26 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
    27 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
    28 PELL_SCHED_AWARD Number(5,0) INTEGER NOT NULL Scheduled Pell Award
    29 PREV_ISIR_TXN_NBR Number(2,0) SMALLINT NOT NULL Previously Acpt ISIR Txn Nbr
    30 PREV_PELL_EFC Number(5,0) INTEGER NOT NULL Previously Acpt EFC
    31 PREV_SEC_EFC_FLAG Character(1) VARCHAR2(1) NOT NULL Previously Acpt Secndry EFC Cd
    32 PREV_PELL_BDGT_COA Number(8,2) DECIMAL(7,2) NOT NULL Previously Acpt Cost of Attdnc
    33 PG_ED_USE_FLAG_1 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 1
    1=Shared SAR ID
    34 PG_ED_USE_FLAG_2 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 2
    1=Verification W Status
    35 PG_ED_USE_FLAG_3 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 3
    1=Concurrent Enrollment
    36 PG_ED_USE_FLAG_4 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 4
    1=POP
    37 PG_ED_USE_FLAG_5 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 5
    38 PG_ED_USE_FLAG_6 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 6
    39 PG_ED_USE_FLAG_7 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 7
    40 PG_ED_USE_FLAG_8 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 8
    41 PG_ED_USE_FLAG_9 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 9
    42 PG_ED_USE_FLAG_10 Character(1) VARCHAR2(1) NOT NULL Ed Use Flag 10
    43 PELL_MANUAL_OVRD Character(1) VARCHAR2(1) NOT NULL Pell Manual Override

    Y/N Table Edit

    44 SFA_ADDL_PELL_ELIG Character(1) VARCHAR2(1) NOT NULL Additional Pell Eligibility

    Y/N Table Edit

    45 SFA_COD_CITZN_STAT Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    1=U.S. Citizen
    2=Eligible Non-Citizen
    3=Not Eligible
    46 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
    47 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
    48 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
    49 SFA_ATB_STATE_CD Character(2) VARCHAR2(2) NOT NULL Ability to Benefit State Code

    Prompt Table: SFA_ISIRSTATEVW

    50 SFA_ATB_COMP_DT Date(10) DATE Ability to Benefit Completion Date
    51 SFA_MAX_PELLIND Character(1) VARCHAR2(1) NOT NULL 2425: Maximum Pell Indicator
    52 SFA_MIN_PELLIND Character(1) VARCHAR2(1) NOT NULL 2425: Minimum Pell Indicator