HCSC_CLK_LCKDTL(SQL Table) |
Index Back |
---|---|
Search Results grid record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |