SSR_AC_CONTCAFL

(SQL Table)
Index Back

Activity Content Item CAF Lang

Related Language record for SSR_AC_CONT_CAF.

  • Related Language Record for SSR_AC_CONT_CAF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_AC_CONTENT_ID Character(13) VARCHAR2(13) NOT NULL Activity Registry ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SSR_AC_ITEM_ID Character(10) VARCHAR2(10) NOT NULL Content Item ID
    5 SCC_CAF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Attribute Sequence
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

    Prompt Table: SCC_CAF_ATTRIBS

    8 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
    9 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
    10 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value