# Business Logic — JBSbatKKRsvTokiHak.executeKK_T_SVC_KEI_UCWK_PKINSERT() [92 LOC]

| Field | Value |
|-------|-------|
| Fully Qualified Name | `eo.business.service.JBSbatKKRsvTokiHak` |
| Layer | Service |
| Module | `service` (Package: `eo.business.service`) |

## 1. Role

### JBSbatKKRsvTokiHak.executeKK_T_SVC_KEI_UCWK_PKINSERT()

This method performs the **insert** of a service contract detail (Service Contract Line Item) record into the database using a **primary-key-based full-field registration** pattern. In the service management domain, when a new service contract line item needs to be created — encompassing every possible field including scheduling, billing, status, cancellation, pause, and administrative metadata — this method serves as the dedicated persistence layer entry point. It acts as a **delegation handler**: it receives a flat `Object[]` array, maps each element into a structured key-value container, and delegates the actual SQL insert to `JBSbatSQLAccess.insertByPrimaryKeys()`. The method is called by `JBSbatKKRsvTokiHak.insertSvcKeiUcwk()`, which is the public-facing service method that prepares the parameter array before invoking this low-level persistence operation. It implements a **builder-delegate design pattern**: the method constructs a value-setter map and immediately routes it to the SQL access layer. There are no conditional branches — the method executes a straightforward, sequential field-to-database mapping followed by a single insert call.

## 2. Processing Pattern (Detailed Business Logic)

```mermaid
flowchart TD
    START(["executeKK_T_SVC_KEI_UCWK_PKINSERT(params)"])
    START --> S1["S1: Create JBSbatCommonDBInterface setMap"]
    S1 --> MAP["Map 79 fields from setParam[] to setMap via setValue(key, value)"]
    MAP --> MAP_DETAIL["Map indices 0-48: core contract fields (SVC_KEI_UCWK_NO through SVC_CHRG_ENDYMD)"]
    MAP_DETAIL --> MAP_EXTRAS["Map indices 49-65: added fields (SVC_DSL_KISAN_YMD, KEIZK_MT_SVC_KEI_UCWK_NO, KEIZK_AF_KEI_CHGECHU_FLG)"]
    MAP_EXTRAS --> MAP_AUDIT["Map indices 66-78: audit/tracking fields (ADD_DTM through DEL_TRN_ID)"]
    MAP_AUDIT --> INSERT["DB: db_KK_T_SVC_KEI_UCWK.insertByPrimaryKeys(setMap)"]
    INSERT --> END_NODE(["Return / Next"])
```

**CRITICAL — Constant Resolution:**
- `D_TBL_NAME_KK_T_SVC_KEI_UCWK` = `"KK_T_SVC_KEI_UCWK"` (Service Contract Detail master table — defined as a private static final String in `JBSbatKKRsvTokiHak`).
- `db_KK_T_SVC_KEI_UCWK` is a `JBSbatSQLAccess` instance initialized with the table name `KK_T_SVC_KEI_UCWK`.

**Processing Flow:**
1. **Object creation**: A `JBSbatCommonDBInterface` (key-value map) named `setMap` is instantiated.
2. **Field mapping (79 fields)**: The method iterates over the `setParam` array (indexed 0–78) and calls `setMap.setValue(key, value)` for each index, associating each position with its corresponding database column name. The fields cover:
   - **Core contract data** (indices 0–48): Contract numbers, dates, codes, statuses
   - **Expanded fields** (indices 49–65): Added by bug-fix OT-2013-0000311 (20130406), including settlement linkage fields
   - **Audit/tracking fields** (indices 66–78): Timestamps and operator accounts for add/update/delete lifecycle
3. **Primary-key insert**: `db_KK_T_SVC_KEI_UCWK.insertByPrimaryKeys(setMap)` executes the database INSERT against the `KK_T_SVC_KEI_UCWK` table using the mapped key-value pairs.
4. **Return**: Method returns `void` — either succeeds silently or throws an `Exception` from the SQL layer.

## 3. Parameter Analysis

| No | Parameter Name | Type | Business Description |
|----|---------------|------|---------------------|
| 1 | `setParam` | `Object[]` | An ordered array of 79 values representing every field of a service contract line item to be registered. Each index maps to a specific database column (see field key mapping in Javadoc). Index 0 = contract detail number, indices 1–48 = core service/contract/dates/codes, indices 49–65 = supplementary fields (added in OT-2013-0000311), indices 66–78 = audit trail fields (add/update/delete timestamps and operator accounts). |

**Instance fields used by this method:**

| Field | Type | Business Description |
|-------|------|---------------------|
| `db_KK_T_SVC_KEI_UCWK` | `JBSbatSQLAccess` | SQL access handler configured for the `KK_T_SVC_KEI_UCWK` table; provides `insertByPrimaryKeys()`. |

## 4. CRUD Operations / Called Services

| CRUD | SC / CBS | SC Code | Entity / DB | Operation Description |
|------|----------|---------|-------------|----------------------|
| C | `db_KK_T_SVC_KEI_UCWK.insertByPrimaryKeys` | - | `KK_T_SVC_KEI_UCWK` | Inserts a new service contract detail record with all 79 fields populated as primary key and data columns |
| - | `JBSbatCommonDBInterface.setValue` | JDKStructuredMap | - | Sets a key-value pair in the intermediate data map (called 79 times, once per field) |
| - | `JBSbatCommonDBInterface.setValue` | - | - | Sets field values mapping index positions from `setParam` array to column name keys (e.g., `SVC_KEI_UCWK_NO`, `SVC_KEI_NO`, etc.) |

**How to classify:**
- **C (Create)**: `insertByPrimaryKeys()` — writes a new row to the `KK_T_SVC_KEI_UCWK` table with all fields populated. This is a primary-key insert meaning the record is uniquely identified by its primary key columns.

**Entity/DB table:**
- `KK_T_SVC_KEI_UCWK` — The service contract detail (service contract line item) master table. Contains fields for service contract numbers, scheduling dates, billing periods, status codes, cancellation/pause reasons, operator tracking, and administrative metadata.

## 5. Dependency Trace

### Pre-computed evidence from code analysis graph:

No screen/batch entry points found within 8 hops. Direct callers found: 2 methods.
Terminal operations from this method: `insertByPrimaryKeys` [C], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-], `setValue` [-]  # NOSONAR

| # | Caller (Screen/Batch) | Call Chain (Full Path to this Method) | Terminal (SC / CRUD / Entity) |
|---|----------------------|--------------------------------------|-------------------------------|
| 1 | Method: `JBSbatKKRsvTokiHak.insertSvcKeiUcwk()` | `insertSvcKeiUcwk()` -> `executeKK_T_SVC_KEI_UCWK_PKINSERT(setParam)` | `insertByPrimaryKeys [C] KK_T_SVC_KEI_UCWK` |

**Instructions:**
- Direct caller: `JBSbatKKRsvTokiHak.insertSvcKeiUcwk()` — a service method in the same class that prepares the `setParam` array and delegates to this low-level insert method.
- This method has no screen/batch entry points within 8 hops — it sits deep in the service layer, acting as a utility persistence method called from other service-level logic.

## 6. Per-Branch Detail Blocks

The method has **no conditional branches** (no if/else, switch, loop, or try/catch). The control flow is strictly linear: create map -> set fields -> insert -> return. Therefore, there is a single block:

**Block 1** — [LINEAR PROCESSING] `(no condition)` (L1043)

> Creates the intermediate data map and populates all 79 fields from the parameter array, then delegates to the SQL insert layer.

| # | Type | Code |
|---|------|------|
| 1 | SET | `JBSbatCommonDBInterface setMap = new JBSbatCommonDBInterface();` // Create intermediate key-value map |
| 2 | SET | `setMap.setValue("SVC_KEI_UCWK_NO", setParam[0]);` // [-> Field 0: Service contract detail number] |
| 3 | SET | `setMap.setValue("GENE_ADD_DTM", setParam[1]);` // [-> Field 1: Generation registration timestamp] |
| 4 | SET | `setMap.setValue("SVC_KEI_UCWK_STAT", setParam[2]);` // [-> Field 2: Service contract detail status] |
| 5 | SET | `setMap.setValue("SVC_KEI_NO", setParam[3]);` // [-> Field 3: Service contract number] |
| 6 | SET | `setMap.setValue("MSKM_DTL_NO", setParam[4]);` // [-> Field 4: Order detail number] |
| 7 | SET | `setMap.setValue("PCRS_CD", setParam[5]);` // [-> Field 5: Price course code] |
| 8 | SET | `setMap.setValue("PPLAN_CD", setParam[6]);` // [-> Field 6: Price plan code] |
| 9 | SET | `setMap.setValue("TK_HOSHIKI_KEI_NO", setParam[7]);` // [-> Field 7: Provision method contract number] |
| 10 | SET | `setMap.setValue("PAYWAY_KEIZOKU_FLG", setParam[8]);` // [-> Field 8: Payment method continuation flag] |
| 11 | SET | `setMap.setValue("WEB_OP_ADD_FAIL_FLG", setParam[9]);` // [-> Field 9: Web option addition failure flag] |
| 12 | SET | `setMap.setValue("WORK_RRK_BIKO", setParam[10]);` // [-> Field 10: Business correspondence remarks] |
| 13 | SET | `setMap.setValue("SVC_USE_STA_KIBO_YMD", setParam[11]);` // [-> Field 11: Service use start desired date] |
| 14 | SET | `setMap.setValue("SVC_UEST_KBTMZ_CD", setParam[12]);` // [-> Field 12: Service customer KB month code] |
| 15 | SET | `setMap.setValue("SVC_UEST_KBTM_CD", setParam[13]);` // [-> Field 13: Service customer KB month code] |
| 16 | SET | `setMap.setValue("RSV_TSTA_KIBO_YMD", setParam[14]);` // [-> Field 14: Reservation application start desired date] |
| 17 | SET | `setMap.setValue("SKEKKA_SEND_CD", setParam[15]);` // [-> Field 15: Screening result transmission code] |
| 18 | SET | `setMap.setValue("SVC_KEI_UCWK_KZKWRK_REQYMD", setParam[16]);` // [-> Field 16: Service contract detail follow-up work request date] |
| 19 | SET | `setMap.setValue("SHOSA_YMD", setParam[17]);` // [-> Field 17: Screening date] |
| 20 | SET | `setMap.setValue("SHOSA_CL_YMD", setParam[18]);` // [-> Field 18: Screening cancellation date] |
| 21 | SET | `setMap.setValue("FTRIAL_KANYU_YMD", setParam[19]);` // [-> Field 19: Free trial join date] |
| 22 | SET | `setMap.setValue("FTRIAL_PRD_ENDYMD", setParam[20]);` // [-> Field 20: Free trial period end date] |
| 23 | SET | `setMap.setValue("HONKANYU_YMD", setParam[21]);` // [-> Field 21: Full join date] |
| 24 | SET | `setMap.setValue("HONKANYU_IKO_KIGEN_YMD", setParam[22]);` // [-> Field 22: Full join migration deadline date] |
| 25 | SET | `setMap.setValue("KEI_CNC_YMD", setParam[23]);` // [-> Field 23: Contract conclusion date] |
| 26 | SET | `setMap.setValue("RSV_APLY_YMD", setParam[24]);` // [-> Field 24: Reservation application date] |
| 27 | SET | `setMap.setValue("RSV_CL_YMD", setParam[25]);` // [-> Field 25: Reservation cancellation date] |
| 28 | SET | `setMap.setValue("RSV_APLY_CD", setParam[26]);` // [-> Field 26: Reservation application code] |
| 29 | SET | `setMap.setValue("PLAN_STAYMD", setParam[27]);` // [-> Field 27: Plan start date] |
| 30 | SET | `setMap.setValue("PLAN_ENDYMD", setParam[28]);` // [-> Field 28: Plan end date] |
| 31 | SET | `setMap.setValue("PLAN_CHRG_STAYMD", setParam[29]);` // [-> Field 29: Plan billing start date] |
| 32 | SET | `setMap.setValue("PLAN_CHRG_ENDYMD", setParam[30]);` // [-> Field 30: Plan billing end date] |
| 33 | SET | `setMap.setValue("PLAN_END_SBT_CD", setParam[31]);` // [-> Field 31: Plan end type code] |
| 34 | SET | `setMap.setValue("SVC_CANCEL_YMD", setParam[32]);` // [-> Field 32: Service cancellation date] |
| 35 | SET | `setMap.setValue("SVC_CANCEL_RSN_CD", setParam[33]);` // [-> Field 33: Service cancellation reason code] |
| 36 | SET | `setMap.setValue("SVC_STA_YMD", setParam[34]);` // [-> Field 34: Service start date] |
| 37 | SET | `setMap.setValue("SVC_CHRG_STAYMD", setParam[35]);` // [-> Field 35: Service billing start date] |
| 38 | SET | `setMap.setValue("SVC_STP_YMD", setParam[36]);` // [-> Field 36: Service suspension date] |
| 39 | SET | `setMap.setValue("SVC_STP_RSN_CD", setParam[37]);` // [-> Field 37: Service suspension reason code] |
| 40 | SET | `setMap.setValue("SVC_STP_RLS_YMD", setParam[38]);` // [-> Field 38: Service suspension release date] |
| 41 | SET | `setMap.setValue("SVC_STP_RLS_RSN_CD", setParam[39]);` // [-> Field 39: Service suspension release reason code] |
| 42 | SET | `setMap.setValue("PAUSE_STP_CD", setParam[40]);` // [-> Field 40: Pause interruption code] |
| 43 | SET | `setMap.setValue("SVC_PAUSE_YMD", setParam[41]);` // [-> Field 41: Service pause date] |
| 44 | SET | `setMap.setValue("SVC_PAUSE_RSN_CD", setParam[42]);` // [-> Field 42: Service pause reason code] |
| 45 | SET | `setMap.setValue("SVC_PAUSE_RSN_MEMO", setParam[43]);` // [-> Field 43: Service pause reason memo] |
| 46 | SET | `setMap.setValue("SVC_PAUSE_RLS_YMD", setParam[44]);` // [-> Field 44: Service pause release date] |
| 47 | SET | `setMap.setValue("SVC_PAUSE_RLS_RSN_CD", setParam[45]);` // [-> Field 45: Service pause release reason code] |
| 48 | SET | `setMap.setValue("SVC_PAUSE_RLS_RSN_MEMO", setParam[46]);` // [-> Field 46: Service pause release reason memo] |
| 49 | SET | `setMap.setValue("SVC_ENDYMD", setParam[47]);` // [-> Field 47: Service end date] |
| 50 | SET | `setMap.setValue("SVC_CHRG_ENDYMD", setParam[48]);` // [-> Field 48: Service billing end date] |
| 51 | SET | `setMap.setValue("SVC_DSL_KISAN_YMD", setParam[49]);` // [-> Field 49: Service contract settlement date (OT-2013-0000311 addition)] |
| 52 | SET | `setMap.setValue("SVC_DSL_YMD", setParam[50]);` // [-> Field 50: Service cancellation (deregistration) date] |
| 53 | SET | `setMap.setValue("SVC_DLRE_CD", setParam[51]);` // [-> Field 51: Service deregistration code] |
| 54 | SET | `setMap.setValue("SVC_DLRE_MEMO", setParam[52]);` // [-> Field 52: Service deregistration reason memo] |
| 55 | SET | `setMap.setValue("SVC_DSL_TTDKI_FIN_FLG", setParam[53]);` // [-> Field 53: Service deregistration procedure completion flag] |
| 56 | SET | `setMap.setValue("KAIHK_YMD", setParam[54]);` // [-> Field 54: Recovery date] |
| 57 | SET | `setMap.setValue("SVC_CANCEL_CL_YMD", setParam[55]);` // [-> Field 55: Service cancellation reversal date] |
| 58 | SET | `setMap.setValue("SVC_DSL_CL_YMD", setParam[56]);` // [-> Field 56: Service deregistration reversal date] |
| 59 | SET | `setMap.setValue("SVKEIUW_HKHASYMD", setParam[57]);` // [-> Field 57: Service contract detail carryover occurrence date] |
| 60 | SET | `setMap.setValue("CHRG_STA_YMD_HOSEI_UM", setParam[58]);` // [-> Field 58: Billing start date correction presence flag] |
| 61 | SET | `setMap.setValue("SVC_PAUSE_CHRG_STA_YMD", setParam[59]);` // [-> Field 59: Service pause billing start date] |
| 62 | SET | `setMap.setValue("PNLTY_HASSEI_CD", setParam[60]);` // [-> Field 60: Penalty occurrence code] |
| 63 | SET | `setMap.setValue("IDO_DIV", setParam[61]);` // [-> Field 61: Movement classification] |
| 64 | SET | `setMap.setValue("SHOSA_DSL_FIN_CD", setParam[62]);` // [-> Field 62: Screening deregistration completion code] |
| 65 | SET | `setMap.setValue("SVCTK_BUT_DEL_TRN_JSSI_DTM", setParam[63]);` // [-> Field 63: Service provision material deletion process execution timestamp] |
| 66 | SET | `setMap.setValue("KEIZK_MT_SVC_KEI_UCWK_NO", setParam[64]);` // [-> Field 64: Continuation link target service contract detail number (OT-2013-0000311 addition)] |
| 67 | SET | `setMap.setValue("KEIZK_AF_KEI_CHGECHU_FLG", setParam[65]);` // [-> Field 65: Continuation-after charge change in-progress flag (OT-2013-0000311 addition)] |
| 68 | SET | `setMap.setValue("ADD_DTM", setParam[66]);` // [-> Field 66: Registration timestamp] |
| 69 | SET | `setMap.setValue("ADD_OPEACNT", setParam[67]);` // [-> Field 67: Registering operator account] |
| 70 | SET | `setMap.setValue("UPD_DTM", setParam[68]);` // [-> Field 68: Update timestamp] |
| 71 | SET | `setMap.setValue("UPD_OPEACNT", setParam[69]);` // [-> Field 69: Updating operator account] |
| 72 | SET | `setMap.setValue("DEL_DTM", setParam[70]);` // [-> Field 70: Deletion timestamp] |
| 73 | SET | `setMap.setValue("DEL_OPEACNT", setParam[71]);` // [-> Field 71: Deleting operator account] |
| 74 | SET | `setMap.setValue("MK_FLG", setParam[72]);` // [-> Field 72: Inactive flag] |
| 75 | SET | `setMap.setValue("ADD_UNYO_YMD", setParam[73]);` // [-> Field 73: Registration operation date] |
| 76 | SET | `setMap.setValue("ADD_TRN_ID", setParam[74]);` // [-> Field 74: Registration transaction ID] |
| 77 | SET | `setMap.setValue("UPD_UNYO_YMD", setParam[75]);` // [-> Field 75: Update operation date] |
| 78 | SET | `setMap.setValue("UPD_TRN_ID", setParam[76]);` // [-> Field 76: Update transaction ID] |
| 79 | SET | `setMap.setValue("DEL_UNYO_YMD", setParam[77]);` // [-> Field 77: Deletion operation date] |
| 80 | SET | `setMap.setValue("DEL_TRN_ID", setParam[78]);` // [-> Field 78: Deletion transaction ID] |
| 81 | CALL | `db_KK_T_SVC_KEI_UCWK.insertByPrimaryKeys(setMap);` // [C] INSERT new record into KK_T_SVC_KEI_UCWK |

## 7. Glossary

| Term | Type | Business Meaning |
|------|------|------------------|
| `svc_kei_ucwk_no` | Field | Service contract detail number — internal tracking ID for a service contract line item (specific service offering under a master contract) |
| `svc_kei_no` | Field | Service contract number — the parent contract number that groups related service line items |
| `svc_kei_ucwk_stat` | Field | Service contract detail status — current lifecycle status of the contract line item |
| `mskm_dtl_no` | Field | Order detail number — reference to the specific line item in the original order |
| `pcrs_cd` | Field | Price course code — identifies the pricing tier/course selected for the service |
| `pplan_cd` | Field | Price plan code — the specific billing plan applied to this service line item |
| `tk_hosikiki_kei_no` | Field | Provision method contract number — identifies how the service is provisioned |
| `payway_keizoku_flg` | Field | Payment method continuation flag — indicates whether the payment method continues from a previous contract |
| `web_op_add_fail_flg` | Field | Web option addition failure flag — indicates if a web option addition attempt failed |
| `work_rkk_biko` | Field | Business correspondence remarks — free-text field for business notes |
| `svc_use_sta_kibo_ymd` | Field | Service use start desired date — customer's requested service start date |
| `rsv_tsta_kibo_ymd` | Field | Reservation application start desired date — requested start date for reservation application |
| `skekka_send_cd` | Field | Screening result transmission code — code indicating the result of credit/lifecycle screening |
| `shosa_ymd` / `shosa_cl_ymd` | Field | Screening date / Screening cancellation date — dates related to service screening process |
| `ftrial_kanyu_ymd` / `ftrial_prd_endymd` | Field | Free trial join date / Free trial period end date — dates for free trial enrollment |
| `honkanyu_ymd` / `honkanyu_iko_kigen_ymd` | Field | Full join date / Full join migration deadline date — transition from trial to full service |
| `kei_cnc_ymd` | Field | Contract conclusion date — the date the contract was formally signed/concluded |
| `rsv_aply_ymd` / `rsv_cl_ymd` / `rsv_aply_cd` | Field | Reservation application/cancellation date, Reservation application code — reservation lifecycle tracking |
| `plan_staymd` / `plan_endymd` | Field | Plan start/end date — the active period of the selected plan |
| `plan_chrg_staymd` / `plan_chrg_endymd` | Field | Plan billing start/end date — when billing begins and ends for the plan |
| `plan_end_sbt_cd` | Field | Plan end type code — indicates how/why the plan ended (normal, early, forced, etc.) |
| `svc_cancel_ymd` / `svc_cancel_rsn_cd` | Field | Service cancellation date / Service cancellation reason code — cancellation event tracking |
| `svc_sta_ymd` / `svc_chrg_staymd` | Field | Service start date / Service billing start date — when service and billing begin |
| `svc_stp_ymd` / `svc_stp_rsn_cd` | Field | Service suspension date / Service suspension reason code — suspension event tracking |
| `svc_stp_rls_ymd` / `svc_stp_rls_rsn_cd` | Field | Service suspension release date / reason code — when and why suspension is lifted |
| `pause_stp_cd` / `svc_pause_ymd` | Field | Pause interruption code / Service pause date — temporary service pause (distinct from cancellation) |
| `svc_pause_rsn_cd` / `svc_pause_rsn_memo` | Field | Service pause reason code / Service pause reason memo — why service was paused |
| `svc_pause_rls_ymd` / `svc_pause_rls_rsn_cd` / `svc_pause_rls_rsn_memo` | Field | Service pause release date, reason code, and reason memo — pause termination tracking |
| `svc_endymd` | Field | Service end date — the date the service is fully terminated |
| `svc_chrg_endymd` | Field | Service billing end date — when billing stops |
| `svc_dsl_ymd` / `svc_dlre_cd` / `svc_dlre_memo` | Field | Service deregistration date / deregistration code / deregistration memo — formal deregistration event |
| `svc_dsl_ttuki_fin_flg` | Field | Service deregistration procedure completion flag — whether deregistration process is fully complete |
| `kaihk_ymd` | Field | Recovery date — date when a suspended/cancelled service was recovered |
| `svc_cancel_cl_ymd` / `svc_dsl_cl_ymd` | Field | Service cancellation reversal date / Service deregistration reversal date — reversing a prior cancellation/deregistration |
| `svkeiuw_hkahasy_ymd` | Field | Service contract detail carryover occurrence date — date of contract detail carryover event |
| `chrg_sta_ymd_hosei_um` | Field | Billing start date correction presence flag — indicates if billing start date was corrected |
| `svc_pause_chrg_sta_ymd` | Field | Service pause billing start date — when billing resumes after a pause |
| `pnlti_hassei_cd` | Field | Penalty occurrence code — code indicating a penalty has been applied |
| `ido_div` | Field | Movement classification — classifies contract movements (e.g., transfer, change, merge) |
| `shosa_dsl_fin_cd` | Field | Screening deregistration completion code — indicates screening deregistration status |
| `svctk_but_del_trn_jssi_dtm` | Field | Service provision material deletion process execution timestamp — when service-provided data/materials were deleted |
| `add_dtm` / `add_opcnt` | Field | Registration timestamp / Registering operator account — who and when the record was created |
| `upd_dtm` / `upd_opcnt` | Field | Update timestamp / Updating operator account — who and when the record was last updated |
| `del_dtm` / `del_opcnt` | Field | Deletion timestamp / Deleting operator account — who and when the record was deleted |
| `mk_flg` | Field | Inactive flag — logical deletion flag (marking record as inactive without physical deletion) |
| `add_unyo_ymd` / `upd_unyo_ymd` / `del_unyo_ymd` | Field | Registration operation date / Update operation date / Deletion operation date — administrative operation dates |
| `add_trn_id` / `upd_trn_id` / `del_trn_id` | Field | Registration/Update/Deletion transaction ID — unique identifiers for the transaction |
| `keizk_mt_svc_kei_ucwk_no` | Field | Continuation link target service contract detail number — links to the target of a continuation (added in OT-2013-0000311) |
| `keizk_af_kei_chgechu_flg` | Field | Continuation-after charge change in-progress flag — indicates ongoing charge change processing for continuation (added in OT-2013-0000311) |
| `kk_t_svc_kei_ucwk` | Table | Service Contract Detail master table — the primary database table storing service contract line item records |
| `JBSbatSQLAccess` | Class | SQL access base class — provides database operations (insertByPrimaryKeys, selectByPrimaryKeys) for a specific table |
| `JBSbatCommonDBInterface` | Class | Common database interface — a key-value map used to pass field data to SQL access methods |
| `insertByPrimaryKeys` | Method | SQL method that performs a primary-key-based INSERT operation on the configured table |
| PK | Abbreviation | Primary Key — registration using the primary key with all fields populated |
| OT | Abbreviation | Operation/Order Ticket — internal ticket/issue tracking system (e.g., OT-2013-0000311) |
| YMD | Abbreviation | Year-Month-Day — date format (YYYYMMDD) |
| DTM | Abbreviation | Date-Time-Millisecond — timestamp format including milliseconds |
| CD | Abbreviation | Code — a coded value representing a classification or status |
| FLG | Abbreviation | Flag — a boolean indicator (true/false, 0/1) |
| MEMO | Abbreviation | Memo — free-text descriptive field |
| HONKANYU | Term | Full service join — transition from trial to full paid service |
| FTRIAL | Term | Free trial — trial period before full service enrollment |
| RSV | Term | Reservation — a scheduled or pending service event |
| SHOSA | Term | Screening — credit/lifecycle screening process for service eligibility |
| IDO | Term | Movement/Transfer — contract changes such as transfers, upgrades, or modifications |