HCSC_CLK_EVLCKTYPEG=General
P=Process
HCSC_CLK_EVENTIDHCSC_CLK_CGRP_IDHCSC_CLK_EVCGVW(SQL View) |
Index Back |
|---|---|
Stores Lock group informationStores Lock group information for an Event ID |
| SELECT CG.HCSC_CLK_EVLCKTYPE ,CG.HCSC_CLK_EVENTID ,CG.HCSC_CLK_CGRP_ID , CG.HCSC_CLK_MSGOV_FLG FROM PS_HCSC_CLK_EVCMGR CG ,PS_HCSC_CLK_GRPDFN GRP WHERE CG.HCSC_CLK_CGRP_ID = GRP.HCSC_CLK_CGRP_ID AND GRP.HCSC_CLK_CGRP_STAT = 'A' |
| # | 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_CGRP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Lock Down Component Group ID |
| 4 | HCSC_CLK_MSGOV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Lock Schedule Options - Enabled, Disable Temporarily. |