SSR_AC_ID_INC

(SQL Table)
Index Back

Activity ID Inclusion

Inclusion record for Forms of Identification (Activity Registry).

# 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 SSR_ID_TYPE Character(12) VARCHAR2(12) NOT NULL Form of Identification

Prompt Table: SSR_IDTYPES_TBL

6 SSR_CW_REQUIRED Character(1) VARCHAR2(1) NOT NULL Mandatory

Y/N Table Edit

Default Value: N

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