SCC_FIELD_SETUP

(SQL Table)
Index Back

Task Management Fields Setup

Fields setup for dynamic rendering of pages

  • Related Language Record: SCC_FIELDSTP_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_PAGE Character(4) VARCHAR2(4) NOT NULL Page
    CONS=Submission Fields
    LAU=Task Launch
    OTRQ=Other Assignment Fields
    SUPR=Supervisor Fields
    THES=Thesis Fields
    TOP=Research Topic Self service
    TOPC=Topic Fields

    Prompt Table: SCC_PAGEXLATVW

    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSFLD_LBL_HC_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SCC_DISPLAY Character(1) VARCHAR2(1) NOT NULL Display
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    5 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    6 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    7 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    8 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time