ISIR_SIGNATURE

(SQL Table)
 Index Back

ISIR Signature records

This table contains entries/rows of student ID's for whom signature information is required by CPS. This is necessary to resolve signature rejects.

  • Parent record: PERSON

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

    Prompt Table: PEOPLE_SRCH

    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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 ORIG_SSN Character(9) VARCHAR2(9) NOT NULL Original SSN
    6 NAME_CD Character(2) VARCHAR2(2) NOT NULL Name Code
    7 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

    Prompt Table: TIV_SCHOOL_TBL

    8 CORR_SIGNED_BY Character(1) VARCHAR2(1) NOT NULL Correction Signed By
    A=Applicant Only
    B=Applicant and Parent
    P=Parent Only
    9 SIGN_INPUT_TYPE Character(1) VARCHAR2(1) NOT NULL Input Record Type
    F=FOTW signature page
    S=FE signature page
    W=RFOTW signature page
    10 REQUEST_DT Date(10) DATE Request Date

    Default Value: %date

    11 PROCESS_DT Date(10) DATE Process Date
    12 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
    C=Complete
    V=Void
    X=W-2c Issued
    13 BATCH_NUMBER Character(23) VARCHAR2(23) NOT NULL CPS Batch Number
    14 REQUEST_ISIR Character(1) VARCHAR2(1) NOT NULL Submit Signature to CPS
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N