SFA_CODID_XF_VW

(SQL View)
 Index Back

COD Routing ID Cross Ref

This table creates cross reference of variousTitle IV School codes (COD Routing ID) against Institution Id.

SELECT INSTITUTION ,SFA_CR_SCHOOL_ID ,SFA_ACTIVE_OPEID FROM PS_SFA_OPEID_XREF WHERE SFA_CR_ID_TYPE = '01'

  • Parent record: AID_YEAR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 SFA_CR_SCHOOL_ID Character(8) VARCHAR2(8) NOT NULL Common School ID/OPEID
    3 SFA_ACTIVE_OPEID Character(1) VARCHAR2(1) NOT NULL Active

    Y/N Table Edit

    Default Value: Y