SSR_AC_CONCAFVW

(SQL View)
Index Back

Activity Content Item CAF View

Activity Content Item CAF View

SELECT SSR_AC_CONTENT_ID ,INSTITUTION ,EFFDT ,SSR_AC_ITEM_ID ,SCC_CAF_ATTR_SEQ ,SCC_CAF_ATTRIB_NM ,SCC_CAF_ATTR_VAL ,SCC_CAF_ATTR_NVAL ,SCC_CAF_ATTR_DVAL ,SCC_CAF_ATTR_TVAL ,SCC_CAF_ATTR_TIME ,SCC_CAF_ATTR_YNO ,SCC_CAF_ATTR_LVAL FROM PS_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 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

Prompt Table: SCC_CAF_ATTRIBS

7 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
8 SCC_CAF_ATTR_NVAL Number(32,11) DECIMAL(31,11) NOT NULL Numeric Value
9 SCC_CAF_ATTR_DVAL Date(10) DATE Date Value
10 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
11 SCC_CAF_ATTR_TIME Time(15) TIMESTAMP Time Value
12 SCC_CAF_ATTR_YNO Character(1) VARCHAR2(1) NOT NULL Yes/No Value

Y/N Table Edit

13 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value