SCC_TM_CFG_FLDS

(SQL Table)
Index Back

Task Config Launch Fields

  • Related Language Record: SCC_TM_CFGFL_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SCC_TM_TASK_ID Character(31) VARCHAR2(31) NOT NULL Template ID

    Prompt Table: PTAI_TMPL_PVW

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SCC_TM_PG_SUBTYPE Character(4) VARCHAR2(4) NOT NULL Region
    ADDR=Addresses
    CAR=Career
    EMAL=Email Addresses
    EMRG=Emergency Contacts
    PHON=Phone Numbers

    Default Value: CAR

    5 SCC_TM_FIELD Character(30) VARCHAR2(30) NOT NULL Field Name

    Prompt Table: SCC_FIELDSVW

    6 SCC_TM_FIELD_LABEL Character(30) VARCHAR2(30) NOT NULL Label
    7 SCC_TM_DISP_OPTN Character(1) VARCHAR2(1) NOT NULL Display Type

    Y/N Table Edit

    Default Value: N

    8 SCC_TM_DISP_PRIM Character(1) VARCHAR2(1) NOT NULL Primary / All
    A=All
    P=Primary
    9 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    10 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    11 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    12 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time