HCSC_CLK_PROD_IDCOUNTRYHCSC_CLK_PRCS_IDHCSC_CLK_PHASEIDHCSC_CLK_RUN_PARMSHCSC_CLK_INSTANCEHCSC_CLK_PRCTBL(SQL Table) |
Index Back |
|---|---|
Process Batch RecordProcess Batch Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_CLK_PROD_ID |
Character(4) | VARCHAR2(4) NOT NULL | Product owner ID |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | HCSC_CLK_PRCS_ID |
Character(20) | VARCHAR2(20) NOT NULL | Process Lockdown Process ID |
| 4 | HCSC_CLK_PHASEID |
Character(10) | VARCHAR2(10) NOT NULL | Process Phase ID |
| 5 | HCSC_CLK_RUN_PARMS |
Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value |
| 6 | HCSC_CLK_INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Number of the deduction to be used (from the setup), for loan and garnishment |
| 7 | HCSC_CLK_SRCBTCHID | Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value |
| 8 | HCSC_CLK_TGTBTCHID | Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value |
| 9 | HCSC_CLK_ADHOCRUN | Character(1) | VARCHAR2(1) NOT NULL | Lock component/s during pay calc or pay confirm batch run. |
| 10 | HCSC_CLK_KEY0_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 11 | HCSC_CLK_KEY0_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 12 | HCSC_CLK_KEY1_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 13 | HCSC_CLK_KEY1_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 14 | HCSC_CLK_KEY2_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 15 | HCSC_CLK_KEY2_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 16 | HCSC_CLK_KEY3_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 17 | HCSC_CLK_KEY3_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 18 | HCSC_CLK_KEY4_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 19 | HCSC_CLK_KEY4_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 20 | HCSC_CLK_KEY5_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 21 | HCSC_CLK_KEY5_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 22 | HCSC_CLK_KEY6_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 23 | HCSC_CLK_KEY6_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 24 | HCSC_CLK_KEY7_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 25 | HCSC_CLK_KEY7_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 26 | HCSC_CLK_KEY8_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 27 | HCSC_CLK_KEY8_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 28 | HCSC_CLK_KEY9_NAME | Character(18) | VARCHAR2(18) NOT NULL | key field name |
| 29 | HCSC_CLK_KEY9_VAL | Character(65) | VARCHAR2(65) NOT NULL | key field char value |
| 30 | HCSC_CLK_PHSRUNFLG | Character(1) | VARCHAR2(1) NOT NULL | Lock component/s during pay calc or pay confirm batch run. |