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 | Character(4) | VARCHAR2(4) NOT NULL |
Academic Content Context Type
CRSE=Coursework |
|
| 2 | Character(20) | VARCHAR2(20) NOT NULL | Action Date ID | |
| 3 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 4 | Character(20) | VARCHAR2(20) NOT NULL |
Academic Content Type
Prompt Table: SSR_AC_ITEMTYPE |
|
| 5 | 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 |