HCSC_CLK_LCKHDR

(SQL Table)
Index Back

Component Group

Used to group components under a Group ID.

  • Related Language Record: HCSC_CLK_LGRPLN
  • Parent Record Of HCSC_CLK_LCKDTL
  • # 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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 HCSC_CLK_LGRP_STAT Character(1) VARCHAR2(1) NOT NULL Lockgroup status-active,inactive
    A=Active
    I=Inactive

    Default Value: A

    5 HCSC_CLK_LGRP_TYPE Character(3) VARCHAR2(3) NOT NULL Lockgrouptype -Product key, user, role
    KEY=Product Key
    ROL=Role
    USR=User
    6 HCSC_CLK_PROD_ID Character(4) VARCHAR2(4) NOT NULL Product owner ID

    Prompt Table: HCSC_CLK_PDKYVW

    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: %EDITTABLE18

    8 HCSC_CLK_LCKLEVEL Character(10) VARCHAR2(10) NOT NULL Lock level

    Prompt Table: HCSC_CLK_PD_LVL

    9 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

    Default Value: INC