SCC_AFL_TBL

(SQL Table)
 Index Back

Affiliation Code Table

Affiliation Code Table

  • Related Language Record: SCC_AFL_TBL_LNG

  • Parent Record Of SCC_AFL_TRGR

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

    Prompt Table: INSTITUTION_TBL

    2 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SCC_AFL_SPONS_DEPT Character(10) VARCHAR2(10) NOT NULL Affiliation Code's Sponsoring Department

    Prompt Table: SCC_DEPT_TBL_VW

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 SCC_AFL_DESCR Character(254) VARCHAR2(254) NOT NULL Affiliations Long Description
    7 SCC_AFL_DESCRSHORT Character(50) VARCHAR2(50) NOT NULL Affiliations Short Description
    8 SCC_AFL_APPCLASS Character(190) VARCHAR2(190) NOT NULL Affiliations Application Class
    9 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PSPACKAGROOT_VW

    10 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    11 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: PSPACKAGCLAS_VW

    12 SCC_AFL_CHLDRN Character(1) VARCHAR2(1) NOT NULL Flag that indicates if an affiliation has child affiliations. Maintained by the system and used by the Affiliation Manager to make processing more effecient.

    Y/N Table Edit

    Default Value: N

    13 SCC_AFL_IS_ROOT Character(1) VARCHAR2(1) NOT NULL Root Affiliation code

    Y/N Table Edit

    Default Value: N

    14 SCC_AFL_FILTER Character(1) VARCHAR2(1) NOT NULL Affiliation Filter

    Y/N Table Edit

    15 SCC_AFL_MANUAL Character(1) VARCHAR2(1) NOT NULL Affiliation Code set Manual

    Y/N Table Edit

    Default Value: N