SSR_ADC_ACT_CON(SQL Table) |
Index Back |
---|---|
Activity Action Date Ctrl ContActivity 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 |