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 |