SFA_PELL_EDIT

(SQL Table)
Index Back

Pell Comparison Results Record

Contains Pell Comparison Results

  • Parent record: SFA_PELL_HEADER
  • # 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    4 SFA_PELL_ALT_IND Character(1) VARCHAR2(1) NOT NULL Schedule Type
    A=Alternate
    R=Regular
    5 SFA_PELL_FA_LOAD Character(1) VARCHAR2(1) NOT NULL Enrollment Schedule
    F=Full-Time
    H=Half-Time
    L=Less than Half-Time
    N=No Unit Load
    T=Three Quarter Time
    6 SFA_PELL_COA_MIN Number(8,0) INTEGER NOT NULL Pell COA Minimum
    7 SFA_PELL_COA_MAX Number(8,0) INTEGER NOT NULL Pell COA Maximum
    8 SFA_PELL_EFC_MIN Number(8,0) INTEGER NOT NULL Pell EFC Minimum
    9 SFA_PELL_EFC_MAX Number(8,0) INTEGER NOT NULL Pell EFC Maximum
    10 SFA_PELL_AWARD Number(8,0) INTEGER NOT NULL Pell Award Value
    11 SFA_PELL_AWARD_XML Number(8,0) INTEGER NOT NULL XML Pell Award
    12 SFA_PELL_STATUS Character(1) VARCHAR2(1) NOT NULL Pell Status
    A=Attached
    D=Deleted
    L=Loaded
    M=Mismatch
    U=Updated
    X=Does Not Exist
    13 SFA_PELL_DELETEALL Character(1) VARCHAR2(1) NOT NULL Delete All Edit Rows for Pell Schedule
    14 SFA_PELL_UPDATEALL Character(1) VARCHAR2(1) NOT NULL Update All Rows for Pell Schedule
    15 SFA_PELL_UPDATESEL Character(1) VARCHAR2(1) NOT NULL Update Selected Rows for Pell Schedule