HCSC_CLK_EVLCKTYPEG=General
P=Process
HCSC_CLK_EVENTIDDefault Value: 1
Prompt Table: PSTIMEZONE
A=Active
I=Inactive
Default Value: A
HCSC_CLK_EVSCHD(SQL Table) |
Index Back |
|---|---|
Lockdown Event SchdeuleLockdown Event Schdeule record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_CLK_EVLCKTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Lockdown type (Process, General )
G=General P=Process |
| 2 | HCSC_CLK_EVENTID |
Character(12) | VARCHAR2(12) NOT NULL | Lockdown Event Definition ID |
| 3 | HCSC_CLK_SCHDL_ID | Number(3,0) | SMALLINT NOT NULL |
Lock group type ID
Default Value: 1 |
| 4 | HCSC_CLK_START_DT | Date(10) | DATE | Start Date |
| 5 | HCSC_CLK_START_TM | Time(15) | TIMESTAMP | Start Time |
| 6 | HCSC_CLK_END_DT | Date(10) | DATE | General lockdown Schedule END Date |
| 7 | HCSC_CLK_END_TIME | Time(15) | TIMESTAMP | General lockdown Schedule END Time |
| 8 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table: PSTIMEZONE |
| 9 | HCSC_CLK_EVNT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Indicates Event mapping status. It shows any of the 4 values - Enabled/Not Enabled/Failed /New
A=Active I=Inactive Default Value: A |