HCSC_CLK_EVLCKTYPEG=General
P=Process
HCSC_CLK_EVENTIDHCSC_CLK_LCKGRP_IDALL=Applies to ALL
INC=Include in Lockdown
XCL=Exclude from Lockdown
KEY=Product Key
ROL=Role
USR=User
HCSC_CLK_EVLGVW(SQL View) |
Index Back |
|---|---|
Stores Lock group informationStores Lock group information for an Event ID |
| SELECT LG.HCSC_CLK_EVLCKTYPE ,LG.HCSC_CLK_EVENTID ,HD.HCSC_CLK_LCKGRP_ID , HD.HCSC_CLK_KEYOPTION ,HD.HCSC_CLK_LCKLEVEL ,HD.HCSC_CLK_LGRP_TYPE ,HD.COUNTRY FROM PS_HCSC_CLK_EVLKGR LG ,PS_HCSC_CLK_LCKHDR HD WHERE LG.HCSC_CLK_LCKGRP_ID = HD.HCSC_CLK_LCKGRP_ID AND HD.HCSC_CLK_LGRP_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_LCKGRP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Payroll Lock Down LockGroup ID |
| 4 | HCSC_CLK_KEYOPTION | Character(3) | VARCHAR2(3) NOT NULL |
Key type- Primary, Alternate
ALL=Applies to ALL INC=Include in Lockdown XCL=Exclude from Lockdown |
| 5 | HCSC_CLK_LCKLEVEL | Character(10) | VARCHAR2(10) NOT NULL | Lock level |
| 6 | HCSC_CLK_LGRP_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Lockgrouptype -Product key, user, role
KEY=Product Key ROL=Role USR=User |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |