SCC_TM_PG_DEFN

(SQL Table)
Index Back

Page Definition

  • Related Language Record: SCC_TM_PGDFN_LN
  • # 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 SCC_TM_PAGE_TYPE Character(3) VARCHAR2(3) NOT NULL Page Type
    AGR=Agreement

    Default Value: AGR

    3 SCC_TM_PAGE_CD Character(15) VARCHAR2(15) NOT NULL Page Code
    4 SCC_TM_PAGE_NAME Character(60) VARCHAR2(60) NOT NULL Page Description
    5 SCC_TM_PG_TITLE Long Character(256) VARCHAR2(256) Page Title
    6 SCC_TM_INSTRUCTION Long Character CLOB NOT NULL Instruction Text
    7 SCC_TM_TSK_ITXT Long Character CLOB NOT NULL Agreement Text
    8 SCC_TM_PRINT Character(1) VARCHAR2(1) NOT NULL Print

    Y/N Table Edit

    Default Value: N

    9 SCC_TM_SAVE Character(1) VARCHAR2(1) NOT NULL Save Agreement

    Y/N Table Edit

    Default Value: Y

    10 SCC_TM_SAVE_AGRTXT Character(1) VARCHAR2(1) NOT NULL Save Agreement Text

    Y/N Table Edit

    Default Value: Y

    11 SCC_TM_SAVE_IP Character(1) VARCHAR2(1) NOT NULL Save IP Address

    Y/N Table Edit

    Default Value: N

    12 SCC_TM_ACC_DEC Character(1) VARCHAR2(1) NOT NULL Accept
    N=Accept Only
    Y=Accept / Decline

    Default Value: Y

    13 SCC_TM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Status
    N=Inactive
    Y=Active

    Default Value: Y

    14 SCC_TM_ACC_LBL Character(100) VARCHAR2(100) NOT NULL Accept
    15 SCC_TM_DEC_LBL Character(100) VARCHAR2(100) NOT NULL Decline
    16 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    17 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    18 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    19 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    20 SCC_TM_COMP_DEC Character(1) VARCHAR2(1) NOT NULL Complete on Decline

    Y/N Table Edit

    Default Value: N