SFA_PELL_COMP

(SQL Table)
 Index Back

Pell Table Run Control Record

Used in Pell Table Enablement Load run control page.

  • Related Language Record: SFA_PELL_CM_LNG

    • # 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 SFA_PELL_ALT_IND Character(1) VARCHAR2(1) NOT NULL Schedule Type
    A=Alternate
    R=Regular

    Default Value: R

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

    Prompt Table: FED_AID_YR_TBL

    5 SFA_PELL_ATTACHFIL Character(128) VARCHAR2(128) NOT NULL Attached File
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 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
    8 ATTACHADD Character(1) VARCHAR2(1) NOT NULL Add Attachment
    9 ATTACHDELETE Character(1) VARCHAR2(1) NOT NULL Delete Attachment
    10 ATTACHVIEW Character(1) VARCHAR2(1) NOT NULL View Attachment