HCSC_CLK_LHD_VW(SQL View) |
Index Back |
---|---|
Component GroupUsed to group components under a Group ID. |
SELECT HCSC_CLK_LCKGRP_ID , DESCR , HCSC_CLK_LGRP_TYPE FROM PS_HCSC_CLK_LCKHDR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HCSC_CLK_LCKGRP_ID | Character(15) | VARCHAR2(15) NOT NULL | Payroll Lock Down LockGroup ID |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | HCSC_CLK_LGRP_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Lockgrouptype -Product key, user, role
KEY=Product Key ROL=Role USR=User |