STDNT_FATU_DVR

(SQL Table)
 Index Back

Student Fin Aid Term Upd Dvr

This table is used to hold students that need to have FA Term records created. It drives the FA Term Batch assignment process.

  • Parent record: PSOPRDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    5 STRM Character(4) VARCHAR2(4) NOT NULL Term
    6 REC_TYPE Character(2) VARCHAR2(2) NOT NULL Record type for discounts and perks eligibility flat file. This field tells the supplier whether the record is a header, detail or footer record.
    7 FAT_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL FAT Status
    C=Created-Awaiting Processing
    E=Error in processing
    P=Processed
    8 PROCESS_DT Date(10) DATE Process Date