ITM_TP_FA_COPY

(SQL View)
 Index Back

Item Type Table

Item Type Table

SELECT a.setid , a.item_type , a.aid_year , a.effdt , a.eff_status , a.descr , a.descrshort , a.pay_across_terms , a.fa_source , a.federal_id , a.loan_program , a.title_iv , a.award_letter_print , a.print_ltr_option , a.fan_print_specs , a.fin_aid_type , a.fed_or_inst , a.package_limit_rule , a.need_based , a.meet_need_cost , a.disburse_method , a.aggregate_area , a.fa_round_option , a.round_direction , a.remainder_rule , a.fee_remainder_rule , a.truncate_fee , a.loan_interest_attr , a.pass_anticip_aid , a.antcp_aid_exp_days , a.packaging_feed , a.equity_award , a.inst_ovrawrd_rule , a.fed_ovrawrd_rule , a.ovrawd_tolerance , a.report_code , a.award_msg_cd , a.signature_release , a.auto_cancel_type , a.manual_auth_ind , a.line_reason_cd , a.parent_item_type , a.selection_criteria , a.methodology , a.self_help_award , a.lock_award_flag , a.award_period , a.one_instance_item , a.missing_term_split , a.disb_protection , a.sequence_override , a.include_in_tscrpt , a.fa_ss_accept , a.fa_ss_decline , a.fa_ss_redux , a.sfa_mpn_required , a.sfa_lntransit_flag , a.sfa_no_rpkg_flag , a.sfa_asg_acad_level , a.sfa_addl_pell_elig , a.descrlong FROM PS_ITEM_TYPE_FA a

  • Parent record: ITEM_FA_CD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYP_FA3_VW

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

    Prompt Table: FED_AID_YR_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 PAY_ACROSS_TERMS Character(1) VARCHAR2(1) NOT NULL Pay Fin Aid Across Terms

    Y/N Table Edit

    9 FA_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
    F=Federal
    G=Government
    I=Institutional
    O=Other
    P=Private
    S=State
    10 FEDERAL_ID Character(4) VARCHAR2(4) NOT NULL Federal ID
    ACG=Academic Competitiveness Grant
    FWSP=Federal Work Study Program
    GAAN=Grad Assistance in Natl Need
    GPLS=Graduate PLUS Loan
    HEAL=Health Education Assistance Ln
    HPSL=Health Profession Student Loan
    IASA=Iraq/Afghan Service Award
    JVTS=Jacob K Javits Fellowship
    LDS=Loans for Disadvantaged Stdnts
    NIH=National Institute of Health
    NSF=National Science Foundation
    NURS=Nursing Loan
    OTHR=Other Federal Fund
    PCL=Primary Care Loan
    PELL=Federal PELL Grant
    PERK=Federal Perkins Loan Program
    PLUS=Federal Stafford Loan, PLUS
    SEOG=Federal SEOG
    SMRT=National Smart Grant
    STFS=Fed Stafford Loan - Subsidized
    STFU=Fed Stafford Loan-Unsubsidized
    TCH=TEACH Grant
    11 LOAN_PROGRAM Character(1) VARCHAR2(1) NOT NULL Loan Program
    A=Alternative
    D=Direct Lending
    F=FFELP
    H=Health Professions
    P=Perkins
    S=State
    U=University
    12 TITLE_IV Character(1) VARCHAR2(1) NOT NULL Title IV Aid

    Y/N Table Edit

    13 AWARD_LETTER_PRINT Character(3) VARCHAR2(3) NOT NULL Award Letter Print

    Prompt Table: SCC_STN_LTR_TBL

    14 PRINT_LTR_OPTION Character(1) VARCHAR2(1) NOT NULL Print Letter Option
    C=Print on Custom Letter
    N=Never print on letter
    P=Print on Award Letter
    15 FAN_PRINT_SPECS Character(1) VARCHAR2(1) NOT NULL FAN Print Specification
    A=Print as Award Item
    O=Print as Other Resource
    16 FIN_AID_TYPE Character(4) VARCHAR2(4) NOT NULL Fin Aid Type
    A=Athletic
    B=Bursary
    F=Fellowship
    G=Grant
    L=Loan
    S=Scholarship
    V=Waiver
    W=Work/Study
    17 FED_OR_INST Character(1) VARCHAR2(1) NOT NULL Fed/Inst Affected
    B=Both Fed and Inst
    F=Federal Only
    I=Institutional Only
    18 PACKAGE_LIMIT_RULE Character(1) VARCHAR2(1) NOT NULL Package Limit
    C=Cost of Attendance
    E=EFC/COA lessor
    N=Need
    U=No Limit

    Default Value: N

    19 NEED_BASED Character(1) VARCHAR2(1) NOT NULL Need Based

    Y/N Table Edit

    Default Value: N

    20 MEET_NEED_COST Character(1) VARCHAR2(1) NOT NULL Meet Need/Cost
    1=Straight Need/Cost
    2=Need Only
    3=Cost Only
    4=Special Need/Cost
    5=Conditional
    6=No Effect

    Default Value: 1

    21 DISBURSE_METHOD Character(1) VARCHAR2(1) NOT NULL Disbursement Method
    A=Student Account
    N=No
    22 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area

    Prompt Table: ITEM_TP_FA_AGGR

    23 FA_ROUND_OPTION Character(1) VARCHAR2(1) NOT NULL Rounding Option
    1=Round Even Dollar
    2=5 Dollars
    3=10 Dollars
    4=100 Dollars
    5=No Rounding
    6=Commonline

    Default Value: 1

    24 ROUND_DIRECTION Character(1) VARCHAR2(1) NOT NULL Round Direction
    D=Round Down
    N=Round Nearest
    U=Round Up

    Default Value: N

    25 REMAINDER_RULE Character(1) VARCHAR2(1) NOT NULL Award Remainder Rule
    1=First Disbursment - Cents
    2=Last Disbursement - Cents
    3=First Disbursement - Dollars
    4=Last Disbursement - Dollars

    Default Value: 1

    26 FEE_REMAINDER_RULE Character(1) VARCHAR2(1) NOT NULL Fee Remainder Rule
    1=First Disb - Cents
    2=Last Disb - Cents
    3=First Disb - Dollars
    4=Last Disb - Dollars
    27 TRUNCATE_FEE Character(1) VARCHAR2(1) NOT NULL Truncate Fees

    Y/N Table Edit

    Default Value: N

    28 LOAN_INTEREST_ATTR Character(1) VARCHAR2(1) NOT NULL Loan Interest Attribute
    S=Subsidized
    U=Unsubsidized
    29 PASS_ANTICIP_AID Character(1) VARCHAR2(1) NOT NULL Pass Anticipated Aid
    1=Award Offered
    2=Award Accepted
    3=Award Authorized
    4=No Anticipated Aid

    Default Value: 4

    30 ANTCP_AID_EXP_DAYS Number(3,0) SMALLINT NOT NULL Anticip Aid Expiration Days

    Default Value: 30

    31 PACKAGING_FEED Character(1) VARCHAR2(1) NOT NULL Auto Package

    Y/N Table Edit

    32 EQUITY_AWARD Character(1) VARCHAR2(1) NOT NULL Equity Award

    Y/N Table Edit

    33 INST_OVRAWRD_RULE Character(1) VARCHAR2(1) NOT NULL Overaward Rule(Inst)
    1=Allow
    2=Prevent Awarding

    Default Value: 1

    34 FED_OVRAWRD_RULE Character(1) VARCHAR2(1) NOT NULL Overaward Rule(Fed)
    1=Allow
    2=Prevent Awarding

    Default Value: 1

    35 OVRAWD_TOLERANCE Number(5,0) INTEGER NOT NULL Overaward Tolerance
    36 REPORT_CODE Character(4) VARCHAR2(4) NOT NULL Institution Reporting Cd
    37 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message

    Prompt Table: AWD_MESSAGE_VW

    38 SIGNATURE_RELEASE Character(1) VARCHAR2(1) NOT NULL Signature Required

    Y/N Table Edit

    39 AUTO_CANCEL_TYPE Character(12) VARCHAR2(12) NOT NULL Auto Cancel Item Type

    Prompt Table: ITEM_TP_FA_VW

    40 MANUAL_AUTH_IND Character(1) VARCHAR2(1) NOT NULL Manual Authorization

    Y/N Table Edit

    Default Value: N

    41 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
    42 PARENT_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Parent Item Type

    Y/N Table Edit

    Default Value: N

    43 SELECTION_CRITERIA Character(12) VARCHAR2(12) NOT NULL Selection Criteria

    Prompt Table: SFA_PKGEQTNS_VW

    44 METHODOLOGY Character(2) VARCHAR2(2) NOT NULL Packaging Methodology
    FM=Federal Methodology
    IM=Institutional Methodology
    45 SELF_HELP_AWARD Character(1) VARCHAR2(1) NOT NULL Self Help Award

    Y/N Table Edit

    46 LOCK_AWARD_FLAG Character(1) VARCHAR2(1) NOT NULL Lock Award

    Y/N Table Edit

    47 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard

    Default Value: A

    48 ONE_INSTANCE_ITEM Character(1) VARCHAR2(1) NOT NULL Package Only Once
    49 MISSING_TERM_SPLIT Character(1) VARCHAR2(1) NOT NULL Even split across valid terms
    50 DISB_PROTECTION Character(1) VARCHAR2(1) NOT NULL Disbursement Protection
    51 SEQUENCE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Auto assign lowest sequence
    52 INCLUDE_IN_TSCRPT Character(1) VARCHAR2(1) NOT NULL Include in Transcript
    53 FA_SS_ACCEPT Character(1) VARCHAR2(1) NOT NULL Accept
    54 FA_SS_DECLINE Character(1) VARCHAR2(1) NOT NULL Decline
    55 FA_SS_REDUX Character(1) VARCHAR2(1) NOT NULL Reduce
    56 SFA_MPN_REQUIRED Character(1) VARCHAR2(1) NOT NULL MPN Required
    57 SFA_LNTRANSIT_FLAG Character(1) VARCHAR2(1) NOT NULL Adjust while in transit

    Y/N Table Edit

    Default Value: N

    58 SFA_NO_RPKG_FLAG Character(1) VARCHAR2(1) NOT NULL Don't Auto Repackage

    Y/N Table Edit

    Default Value: N

    59 SFA_ASG_ACAD_LEVEL Character(1) VARCHAR2(1) NOT NULL Academic Level
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year
    6=Grad/Professional - 1st Year
    7=Grad/Professional - Continuing
    60 SFA_ADDL_PELL_ELIG Character(1) VARCHAR2(1) NOT NULL Additional Pell Eligibility
    61 DESCRLONG Long Character CLOB Long Description