SSR_ADC_ACT_CON

(SQL Table)
Index Back

Activity Action Date Ctrl Cont

Activity Action Date Control by Content Type

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
CRSE=Coursework
2 SSR_ADC_ACTN_ID Character(20) VARCHAR2(20) NOT NULL Action Date ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type

Prompt Table: SSR_AC_ITEMTYPE

5 SSR_ADC_ACTN_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
C=Confirm
ER=EOC Remove
ES=EOC Select
R=Remove
RR=Resit - Remove
RS=Resit - Select
S=Select
U=Unconfirm
6 SSR_ADC_START_ID Character(20) VARCHAR2(20) NOT NULL Start Date Source

Prompt Table: SSR_ADC_ACTSTVW

7 SSR_START_DTTM DateTime(26) TIMESTAMP Start Date & Time
8 SSR_ADC_START_ADJ Signed Number(4,0) DECIMAL(3) NOT NULL Adjust Start Date
9 SSR_ADC_START_SRCE Character(1) VARCHAR2(1) NOT NULL Use Time From Start Source

Y/N Table Edit

Default Value: N

10 SSR_ADC_START_TIME Time(15) TIMESTAMP Start Time

Default Value: 00:00:00

11 SSR_ADC_END_ID Character(20) VARCHAR2(20) NOT NULL End Date Source

Prompt Table: SSR_ADC_ACTENVW

12 SSR_END_DTTM DateTime(26) TIMESTAMP End Date & Time
13 SSR_ADC_END_ADJ Signed Number(4,0) DECIMAL(3) NOT NULL Adjust End Date
14 SSR_ADC_END_SRCE Character(1) VARCHAR2(1) NOT NULL Use Time From End Source

Y/N Table Edit

Default Value: N

15 SSR_ADC_END_TIME Time(15) TIMESTAMP End Time

Default Value: 23:59:00

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