HCSC_CLK_LCKDTL

(SQL Table)
Index Back

Search Results grid record

  • Parent record: 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 HCSC_CLK_LVLKEY_ID Number(3,0) SMALLINT NOT NULL Lock group type ID

    Default Value: 1

    3 HCSC_CLK_KEY0_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    4 HCSC_CLK_KEY0_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    5 HCSC_CLK_KEY0_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE2

    6 HCSC_CLK_KEY0_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    7 HCSC_CLK_KEY0_DATE Date(10) DATE key date
    8 HCSC_CLK_KEY1_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    9 HCSC_CLK_KEY1_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    10 HCSC_CLK_KEY1_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE3

    11 HCSC_CLK_KEY1_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    12 HCSC_CLK_KEY1_DATE Date(10) DATE key date
    13 HCSC_CLK_KEY2_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    14 HCSC_CLK_KEY2_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    15 HCSC_CLK_KEY2_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE4

    16 HCSC_CLK_KEY2_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    17 HCSC_CLK_KEY2_DATE Date(10) DATE key date
    18 HCSC_CLK_KEY3_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    19 HCSC_CLK_KEY3_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    20 HCSC_CLK_KEY3_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE5

    21 HCSC_CLK_KEY3_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    22 HCSC_CLK_KEY3_DATE Date(10) DATE key date
    23 HCSC_CLK_KEY4_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    24 HCSC_CLK_KEY4_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    25 HCSC_CLK_KEY4_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE6

    26 HCSC_CLK_KEY4_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    27 HCSC_CLK_KEY4_DATE Date(10) DATE key date
    28 HCSC_CLK_KEY5_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    29 HCSC_CLK_KEY5_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    30 HCSC_CLK_KEY5_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE7

    31 HCSC_CLK_KEY5_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    32 HCSC_CLK_KEY5_DATE Date(10) DATE key date
    33 HCSC_CLK_KEY6_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    34 HCSC_CLK_KEY6_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    35 HCSC_CLK_KEY6_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE8

    36 HCSC_CLK_KEY6_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    37 HCSC_CLK_KEY6_DATE Date(10) DATE key date
    38 HCSC_CLK_KEY7_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    39 HCSC_CLK_KEY7_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    40 HCSC_CLK_KEY7_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE9

    41 HCSC_CLK_KEY7_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    42 HCSC_CLK_KEY7_DATE Date(10) DATE key date
    43 HCSC_CLK_KEY8_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    44 HCSC_CLK_KEY8_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    45 HCSC_CLK_KEY8_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE10

    46 HCSC_CLK_KEY8_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    47 HCSC_CLK_KEY8_DATE Date(10) DATE key date
    48 HCSC_CLK_KEY9_NAME Character(18) VARCHAR2(18) NOT NULL key field name
    49 HCSC_CLK_KEY9_VAL Character(65) VARCHAR2(65) NOT NULL key field char value
    50 HCSC_CLK_KEY9_PMT Character(50) VARCHAR2(50) NOT NULL Key - value prompt

    Prompt Table: %EDITTABLE11

    51 HCSC_CLK_KEY9_NUM Number(15,0) DECIMAL(15) NOT NULL key number value
    52 HCSC_CLK_KEY9_DATE Date(10) DATE key date