# Business Logic — JBSbatKKAdChgAddDataCst.setAdChgNewKojiak() [85 LOC]

| Field | Value |
|-------|-------|
| Fully Qualified Name | `eo.business.service.JBSbatKKAdChgAddDataCst` |
| Layer | Service (Batch Processing Component / CC/Common Component) |
| Module | `service` (Package: `eo.business.service`) |

## 1. Role

### JBSbatKKAdChgAddDataCst.setAdChgNewKojiak()

This method sets the **address-change confirmation details** (住所変更確定情報) for a work order (工事案件) into the output map during a batch process that finalizes customer address changes. It is a shared utility method within the K-Opticom customer core system's batch processing layer, meaning it is reused across multiple batch entry points (called directly by `JBSbatKKAdChgAddDataCst.execute()`) and not tied to any single screen.

The method implements a **routing/dispatch design pattern**: it reads the confirmed work order data from the `KU_T_KOJIAK` table and, based on the service code (`svcCd`), writes different sets of output fields to the `outMap` for either **Net/Telephone services** (service codes `"01"` or `"02"`) or **TV services** (service codes matching `"03"` suffix). A secondary query against `KU_T_SVKEI_KOJIAK` (service contract work order master) populates additional "current basic work order" fields, conditional on whether the service contract line item has no reserved/attached service (`existKojiAkTgSvcKei` returns false).

The method also computes and sets synchronization timestamps (`ADCHG_FIX_DTM`, `KOJI_UK_OPTNTY_IDO_DTM`) using the current operation date-time, and determines whether the **OPMS change linkage flag** (`OPMS_CHGE_RNKI_YH_NET` / `OPMS_CHGE_RNKI_YH_TV`) should be set to ON or OFF based on the work order acceptance status — if the status is `"130" (Acceptance Completed / 受付済)`, the flag is OFF (linkage not required); otherwise it is ON (linkage required).

Crucially, the method filters out work orders that have been **cancelled** (state `"900"`) either at the top level (`KOJIAK_STAT`) or at the specific work order line level (`MANS_KOJIAK_STAT_CD`), ensuring cancelled orders are excluded from address-change confirmation processing. This exclusion was added in version 20.00.00 (v20.00.00 ADD).

## 2. Processing Pattern (Detailed Business Logic)

```mermaid
flowchart TD
    START(["setAdChgNewKojiak_outMap_svcCd_adchgNo_svcKeiNo"])
    Q1(["Query KU_T_KOJIAK via executeKU_T_KOJIAK_KK_SELECT_012"])
    R1["adchgFix4KojiInfo = db selectNext"]
    C1{adchgFix4KojiInfo != null<br/>AND KOJIAK_SBT_CD is 003 or 007}
    B1{KOJIAK_STAT != 900<br/>AND MANS_KOJIAK_STAT_CD != 900}
    C2{svcCd is NET or TEL<br/>OR svcCd endsWith 03}
    S_NET["Set NET_TV fields<br/>ITNS_KOJIAK_NO_NET<br/>ITNS_KOJIAK_UPD_DTM_NET"]
    C2A{KOJIAK_STAT is 130<br/>OR MANS_KOJIAK_STAT_CD is 130}
    S_CHGE_OFF["Set OPMS_CHGE_RNKI_YH_NET = OFF"]
    S_CHGE_ON["Set OPMS_CHGE_RNKI_YH_NET = ON"]
    S_TV["Set TV fields<br/>ITNS_KOJIAK_NO_TV<br/>ITNS_KOJIAK_UPD_DTM_TV"]
    S_CHGE_TV_OFF["Set OPMS_CHGE_RNKI_YH_TV = OFF"]
    S_CHGE_TV_ON["Set OPMS_CHGE_RNKI_YH_TV = ON"]
    S_COMMON["Set ADCHG_FIX_DTM and<br/>KOJI_UK_OPTNTY_IDO_DTM<br/>getOpeDateTime"]
    Q2(["Query KU_T_SVKEI_KOJIAK<br/>executeKU_T_SVKEI_KOJIAK_KK_SELECT_008"])
    R2["rcntKihonKojiInfo = db selectNext"]
    C3{rcntKihonKojiInfo != null}
    C4{svcCd is NET or TEL<br/>OR svcCd endsWith 03}
    C5{existKojiAkTgSvcKei false}
    S_CUR_NET["Set CUR_KIHON_KOJIAK_NO_NET<br/>and UPD_DTM_NET"]
    S_CUR_TV["Set CUR_KIHON_KOJIAK_NO_TV<br/>and UPD_DTM_TV"]
    S_COMMON2["Set KOJI_UK_OPTNTY_IDO_DTM<br/>getOpeDateTime"]
    END(["Return void"])

    START --> Q1
    Q1 --> R1
    R1 --> C1
    C1 -- true --> B1
    C1 -- false --> END
    B1 -- true --> C2
    B1 -- false --> END
    C2 -- NETTEL --> S_NET
    C2 -- TV --> S_TV
    C2 -- else --> S_COMMON
    S_NET --> C2A
    S_TV --> C2A
    C2A -- true --> S_CHGE_OFF
    C2A -- false --> S_CHGE_ON
    S_CHGE_OFF --> S_COMMON
    S_CHGE_ON --> S_COMMON
    S_CHGE_TV_OFF --> S_COMMON
    S_CHGE_TV_ON --> S_COMMON
    S_COMMON --> Q2
    Q2 --> R2
    R2 --> C3
    C3 -- true --> C4
    C3 -- false --> END
    C4 -- NETTEL --> C5
    C4 -- TV --> S_CUR_TV
    C4 -- else --> S_COMMON2
    C5 -- true --> S_CUR_NET
    C5 -- false --> S_COMMON2
    S_CUR_NET --> S_COMMON2
    S_CUR_TV --> S_COMMON2
    S_CHGE_TV_OFF --> S_COMMON
    S_CHGE_TV_ON --> S_COMMON
    S_COMMON2 --> END
```

**Branch explanations:**

- **C1 (Line ~1810):** After querying the work order table, checks if the record exists and if its work order type code (`KOJIAK_SBT_CD`) is either `"003"` (Address Change - New Installation / 住所変更(新設)) or `"007"` (Relocation / 移設). Previously (pre-IT1-2014-0000288), it additionally required the work order status to NOT be `"120" (Registration Completed / 登録済)`, but this restriction was removed so that newly registered work orders are also included.
- **B1 (Line ~1820):** Filters out cancelled work orders. Both the main work order status (`KOJIAK_STAT`) and the specific work order line status (`MANS_KOJIAK_STAT_CD`) must NOT be `"900" (Cancelled / 中止)`. This check was added in v20.00.00 with the Japanese comment: "Cancelled work orders are excluded from processing — do not set the latest basic work order flag and do not drop the pre-move flag" (中止済工事案件は処理対象外 最新基本工事案件フラグを立てない＆転居元のフラグも落とさない).
- **C2 (Line ~1823):** Dispatches by service type. For Net (`"01"`) or Tel (`"02"`), sets NET-specific output fields. For TV (`"03"` suffix via `endsWith`), sets TV-specific fields. Other service codes are ignored.
- **C2A (Line ~1833):** Determines the OPMS change linkage flag. If the work order status is `"130" (Acceptance Completed / 受付済)`, the flag is OFF (no linkage needed). Otherwise it is ON. The check was also expanded in IT1-2014-0000288 to include `MANS_KOJIAK_STAT_CD`.
- **C3 (Line ~1843):** After the first phase, queries the service contract work order master (`KU_T_SVKEI_KOJIAK`). If a record exists, proceeds to set "current basic work order" fields.
- **C5 (Line ~1851):** For Net/TEL services, only sets the current basic work order number if no reserved service contract is attached to the work order number (`existKojiAkTgSvcKei` returns false). This conditional was added in IT1-2013-0001349: "Only update the latest flag when there is no reserved service contract attached to the work order" (工事案件に紐づくサービス契約に保留されたものが存在しない場合のみ最新フラグを更新).

## 3. Parameter Analysis

| No | Parameter Name | Type | Business Description |
|----|---------------|------|---------------------|
| 1 | `outMap` | `JBSbatServiceInterfaceMap` | The output map into which all confirmed address-change data fields are written. This is the shared interface between this data-preparation method and the calling batch logic that will pass the map downstream to screen output or further processing. |
| 2 | `svcCd` | `String` | Service code that determines which service category the work order belongs to. Values: `"01"` (Net / インターネットサービス), `"02"` (Tel / 電話サービス) trigger NET/TEL field population; `"03"` suffix (TV / テレビサービス) triggers TV field population. Other values cause the service-specific fields to be skipped (ignore). |
| 3 | `adchgNo` | `String` | Address change number (住所変更番号) — the unique identifier for the address change batch processing transaction. Used as the primary key to query the `KU_T_KOJIAK` table and passed to `existKojiAkTgSvcKei` for checking reserved service contracts. |
| 4 | `svcKeiNo` | `String` | Service contract number (サービス契約番号) — identifies the specific service contract line item. Used alongside `adchgNo` to query the `KU_T_KOJIAK` table, and alone to query the service contract work order master `KU_T_SVKEI_KOJIAK`. |

**Instance fields read:**

| Field | Type | Business Description |
|-------|------|---------------------|
| `opeDate` | `String` | Current operation date used as a query parameter when executing `executeKU_T_KOJIAK_KK_SELECT_012` and as the value for timestamp fields (`ADCHG_FIX_DTM`, `KOJI_UK_OPTNTY_IDO_DTM`). |

## 4. CRUD Operations / Called Services

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

| CRUD | SC / CBS | SC Code | Entity / DB | Operation Description |
|------|----------|---------|-------------|----------------------|
| R | `executeKU_T_KOJIAK_KK_SELECT_012` | - | `KU_T_KOJIAK` (工事案件マスタ) | Queries the work order master table by `(adchgNo, svcKeiNo, opeDate)` to retrieve the address-change confirmed work order record. |
| R | `db_KU_T_KOJIAK.selectNext` | - | `KU_T_KOJIAK` | Fetches the next row from the result set of the previous query, returning `JBSbatCommonDBInterface` with work order data. |
| R | `executeKU_T_SVKEI_KOJIAK_KK_SELECT_008` | - | `KU_T_SVKEI_KOJIAK` (サービス契約工事案件マスタ) | Queries the service contract work order master table by `svcKeiNo` to retrieve the current basic work order record. |
| R | `db_KU_T_SVKEI_KOJIAK.selectNext` | - | `KU_T_SVKEI_KOJIAK` | Fetches the next row from the result set, returning basic work order info. |
| R | `existKojiAkTgSvcKei` | - | `KU_T_KOJIAK` | Checks if a reserved service contract exists attached to the given work order number (`adchgNo, KOJIAK_NO`). Queries via `KU_T_KOJIAK_KK_SELECT_028`. Returns `true` if reserved service exists, `false` otherwise. |
| R | `getOpeDateTime` | - | - | Returns the current operation date-time string. Used to set `ADCHG_FIX_DTM` (address change fix date-time), `KOJI_UK_OPTNTY_IDO_DTM` (work order relocation optional transfer date-time), and `CUR_KIHON_KOJIAK_UPD_DTM_NET` / `UPD_DTM_TV` fields. |
| - | `JBSbatKKIFM101.setString` (×12+) | - | - | Writes address-change confirmation fields into the `outMap`. These are the terminal output operations: `ITNS_KOJIAK_NO_NET`, `ITNS_KOJIAK_UPD_DTM_NET`, `ITNS_KOJIAK_NO_TV`, `ITNS_KOJIAK_UPD_DTM_TV`, `OPMS_CHGE_RNKI_YH_NET`, `OPMS_CHGE_RNKI_YH_TV`, `ADCHG_FIX_DTM`, `KOJI_UK_OPTNTY_IDO_DTM`, `CUR_KIHON_KOJIAK_NO_NET`, `CUR_KIHON_KOJIAK_UPD_DTM_NET`, `CUR_KIHON_KOJIAK_NO_TV`, `CUR_KIHON_KOJIAK_UPD_DTM_TV`. |

**Field-by-field breakdown of `setString` calls in `outMap`:**

| # | Target Field Key | Service | Business Meaning |
|---|-----------------|---------|------------------|
| 1 | `ITNS_KOJIAK_NO_NET` | NET/TEL | Work order number (工事案件番号) — the confirmed work order ID for Net/TEL service |
| 2 | `ITNS_KOJIAK_UPD_DTM_NET` | NET/TEL | Work order update date-time (工事案件更新日時) |
| 3 | `OPMS_CHGE_RNKI_YH_NET` | NET/TEL | OPMS change linkage flag (OPMS変更連携要否) — "ON" or "OFF" indicating whether OPMS system linkage is required |
| 4 | `ITNS_KOJIAK_NO_TV` | TV | Work order number for TV service |
| 5 | `ITNS_KOJIAK_UPD_DTM_TV` | TV | Work order update date-time for TV service |
| 6 | `OPMS_CHGE_RNKI_YH_TV` | TV | OPMS change linkage flag for TV service |
| 7 | `ADCHG_FIX_DTM` | Both | Address change fix date-time (住所変更確定日時) — timestamp confirming the address change |
| 8 | `KOJI_UK_OPTNTY_IDO_DTM` | Both | Work order relocation optional transfer date-time (工事移転要否移行日時) — timestamp for optional relocation transfer |
| 9 | `CUR_KIHON_KOJIAK_NO_NET` | NET/TEL | Current basic work order number (カレント基本工事案件番号) — only set when no reserved service contract is attached |
| 10 | `CUR_KIHON_KOJIAK_UPD_DTM_NET` | NET/TEL | Current basic work order update date-time |
| 11 | `CUR_KIHON_KOJIAK_NO_TV` | TV | Current basic work order number for TV |
| 12 | `CUR_KIHON_KOJIAK_UPD_DTM_TV` | TV | Current basic work order update date-time for TV |

## 5. Dependency Trace

| # | Caller (Screen/Batch) | Call Chain (Full Path to this Method) | Terminal (SC / CRUD / Entity) |
|---|----------------------|--------------------------------------|-------------------------------|
| 1 | Batch: `JBSbatKKAdChgAddDataCst.execute()` | `execute()` -> `setAdChgNewKojiak()` | `setString [W] outMap fields`, `setString [W] outMap fields`, `getOpeDateTime [R]`, `executeKU_T_KOJIAK_KK_SELECT_012 [R] KU_T_KOJIAK`, `executeKU_T_SVKEI_KOJIAK_KK_SELECT_008 [R] KU_T_SVKEI_KOJIAK`, `existKojiAkTgSvcKei [R] KU_T_KOJIAK` |

**Notes:**
- This method is a private utility called from the batch entry point `execute()` within the same class `JBSbatKKAdChgAddDataCst`.
- No screen (KKSV*) entry points were found within 8 hops. This method operates exclusively in the batch processing domain.
- Terminal operations are primarily `setString` writes to the `outMap` and `selectBySqlDefine` reads from `KU_T_KOJIAK` and `KU_T_SVKEI_KOJIAK` database tables.

## 6. Per-Branch Detail Blocks

### Block 1 — Query Work Order Master (L1787-1789)

> Queries the work order master (`KU_T_KOJIAK`) to retrieve the address-change confirmed work order record.

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | DECL | `JBSbatCommonDBInterface adchgFix4KojiInfo = null` | Declares the variable to hold the work order record |
| 2 | CALL | `executeKU_T_KOJIAK_KK_SELECT_012(new String[]{adchgNo, svcKeiNo, opeDate})` | Executes SQL query on `KU_T_KOJIAK` table with address change number, service contract number, and operation date as bind parameters [-> SQLKEY: KU_T_KOJIAK_KK_SELECT_012] |
| 3 | EXEC | `adchgFix4KojiInfo = db_KU_T_KOJIAK.selectNext()` | Fetches the next row from the query result set |

### Block 2 — IF: Work Order Type Filter (L1810-1814)

> Checks if the work order record exists and its type is "Address Change - New Installation" (003) or "Relocation" (007). Previously also required status != "120 (Registration Completed)", but this was removed per IT1-2014-0000288.

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | COND | `adchgFix4KojiInfo != null` | Verifies the query returned a record |
| 2 | COND | `KOJIAK_SBT_CD == CD00577_AD_CHG_NEWESTA [="003" (住所変更(新設))]` | Work order type is address change with new installation |
| 3 | COND | `KOJIAK_SBT_CD == CD00577_NEWESTA [="007" (移設)]` | Work order type is relocation |
| 4 | LOGIC | `(003 OR 007)` combined with `!= null` | Must have a valid record AND match one of these two types |

### Block 3 — IF: Cancelled Work Order Exclusion (L1820-1822)

> Filters out cancelled work orders at both the main and line-item level. Added in v20.00.00.

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | COND | `KOJIAK_STAT != CD00474_CHUSHI [="900" (中止)]` | Main work order status is not cancelled |
| 2 | COND | `MANS_KOJIAK_STAT_CD != CD00474_CHUSHI [="900" (中止)]` | Specific work order line status is not cancelled |
| 3 | LOGIC | Both conditions must be true (AND) | Only non-cancelled work orders proceed |

### Block 4 — IF/ELSE-IF/ELSE: Service Type Dispatch (First Phase — L1824-1840)

> Dispatches processing based on the service code, writing NET/TEL or TV-specific fields to the output map. Also determines the OPMS change linkage flag.

#### Block 4.1 — NET/TEL Branch (L1824-1839)

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | COND | `svcCd == SVC_CD_NET [="01"]` | Internet service code |
| 2 | COND | `svcCd == SVC_CD_TEL [="02"]` | Telephone service code |
| 3 | EXEC | `outMap.setString(ITNS_KOJIAK_NO_NET, adchgFix4KojiInfo.getString(KOJIAK_NO))` | Sets work order number for Net/TEL |
| 4 | EXEC | `outMap.setString(ITNS_KOJIAK_UPD_DTM_NET, adchgFix4KojiInfo.getString(UPD_DTM))` | Sets work order update date-time for Net/TEL |
| 5 | COND | `KOJIAK_STAT == CD00474_UK_ZM [="130" (受付済)]` | Work order status is acceptance completed |
| 6 | COND | `MANS_KOJIAK_STAT_CD == CD00474_UK_ZM [="130" (受付済)]` | Line-item status is acceptance completed |
| 7 | EXEC | `outMap.setString(OPMS_CHGE_RNKI_YH_NET, OPMS_CHGE_RNKI_YH_OFF)` | OPMS linkage flag = OFF (no linkage needed, acceptance already done) |
| 8 | ELSE | - | OPMS linkage flag = ON |
| 9 | EXEC | `outMap.setString(OPMS_CHGE_RNKI_YH_NET, OPMS_CHGE_RNKI_YH_ON)` | OPMS linkage flag = ON (linkage required) |

#### Block 4.2 — TV Branch (L1839-1840)

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | COND | `SVC_CD_TV.endsWith(svcCd) [="03" matches "03"...]` | TV service code (using `endsWith` for potential prefix variants) |
| 2 | EXEC | `outMap.setString(ITNS_KOJIAK_NO_TV, adchgFix4KojiInfo.getString(KOJIAK_NO))` | Sets work order number for TV |
| 3 | EXEC | `outMap.setString(ITNS_KOJIAK_UPD_DTM_TV, adchgFix4KojiInfo.getString(UPD_DTM))` | Sets work order update date-time for TV |
| 4 | COND | `KOJIAK_STAT == CD00474_UK_ZM [="130" (受付済)]` | Work order status is acceptance completed |
| 5 | COND | `MANS_KOJIAK_STAT_CD == CD00474_UK_ZM [="130" (受付済)]` | Line-item status is acceptance completed |
| 6 | EXEC | `outMap.setString(OPMS_CHGE_RNKI_YH_TV, OPMS_CHGE_RNKI_YH_OFF)` | OPMS linkage flag for TV = OFF |
| 7 | ELSE | - | OPMS linkage flag for TV = ON |
| 8 | EXEC | `outMap.setString(OPMS_CHGE_RNKI_YH_TV, OPMS_CHGE_RNKI_YH_ON)` | OPMS linkage flag for TV = ON |

#### Block 4.3 — Common Fields (L1840)

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | EXEC | `outMap.setString(ADCHG_FIX_DTM, getOpeDateTime())` | Sets address change fix date-time to current operation date-time |
| 2 | EXEC | `outMap.setString(KOJI_UK_OPTNTY_IDO_DTM, getOpeDateTime())` | Sets work order relocation optional transfer date-time to current operation date-time |

#### Block 4.4 — Ignore Branch (L1840 else)

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | ELSE | - | For service codes that are neither Net/TEL nor TV (e.g., Hosting "04"), skip service-specific field setting |

### Block 5 — Query Service Contract Work Order Master (L1841-1843)

> Queries the service contract work order master to retrieve the current basic work order record.

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | DECL | `JBSbatCommonDBInterface rcntKihonKojiInfo = null` | Declares variable for current basic work order info |
| 2 | CALL | `executeKU_T_SVKEI_KOJIAK_KK_SELECT_008(new String[]{svcKeiNo})` | Executes SQL query on `KU_T_SVKEI_KOJIAK` with service contract number [-> SQLKEY: KK_SELECT_008] |
| 3 | EXEC | `rcntKihonKojiInfo = db_KU_T_SVKEI_KOJIAK.selectNext()` | Fetches the next row from result set |

### Block 6 — IF: Service Contract Record Exists (L1843)

> If the service contract work order master returned a record, proceed to set current basic work order fields.

### Block 6.1 — NET/TEL Branch with Reserved Service Check (L1847-1857)

> For Net/TEL services, only sets the current basic work order number if no reserved service contract exists. Added in IT1-2013-0001349.

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | COND | `svcCd == SVC_CD_NET [="01"]` | Internet service code |
| 2 | COND | `svcCd == SVC_CD_TEL [="02"]` | Telephone service code |
| 3 | COND | `!existKojiAkTgSvcKei(adchgNo, KOJIAK_NO)` | No reserved service contract is attached to this work order |
| 4 | EXEC | `outMap.setString(CUR_KIHON_KOJIAK_NO_NET, rcntKihonKojiInfo.getString(KOJIAK_NO))` | Sets current basic work order number for Net/TEL |
| 5 | EXEC | `outMap.setString(CUR_KIHON_KOJIAK_UPD_DTM_NET, rcntKihonKojiInfo.getString(UPD_DTM))` | Sets current basic work order update date-time for Net/TEL |

### Block 6.2 — TV Branch (L1856-1857)

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | COND | `SVC_CD_TV.endsWith(svcCd)` | TV service code |
| 2 | EXEC | `outMap.setString(CUR_KIHON_KOJIAK_NO_TV, rcntKihonKojiInfo.getString(KOJIAK_NO))` | Sets current basic work order number for TV |
| 3 | EXEC | `outMap.setString(CUR_KIHON_KOJIAK_UPD_DTM_TV, rcntKihonKojiInfo.getString(UPD_DTM))` | Sets current basic work order update date-time for TV |

### Block 6.3 — Common Fields (L1859)

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | EXEC | `outMap.setString(KOJI_UK_OPTNTY_IDO_DTM, getOpeDateTime())` | Re-sets work order relocation optional transfer date-time (same value, idempotent) |

### Block 6.4 — Ignore Branch (L1858 else)

| # | Type | Code | Business Description |
|---|------|------|---------------------|
| 1 | ELSE | - | Non-Net/TEL/non-TV service codes are ignored for current basic work order fields |

## 7. Glossary

| Term | Type | Business Meaning |
|------|------|------------------|
| `adchgNo` | Field | Address change number (住所変更番号) — unique identifier for the address change batch processing transaction |
| `svcCd` | Field | Service code (サービスコード) — classifies the service type: "01" = Net, "02" = Tel, "03" = TV |
| `svcKeiNo` | Field | Service contract number (サービス契約番号) — identifies the specific service contract line item |
| `KOJIAK_SBT_CD` | Field | Work order type code (工事案件種別コード) — classifies the work order type (new installation, address change, relocation, etc.) |
| `KOJIAK_STAT` | Field | Work order status (工事案件状態) — current state of the work order (registration completed, acceptance completed, cancelled, etc.) |
| `MANS_KOJIAK_STAT_CD` | Field | Specific work order line status code (満床工事案件状態コード) — status at the specific work order line level |
| `KU_T_KOJIAK` | DB Table | Work order master table (工事案件マスタ) — stores work order header information |
| `KU_T_SVKEI_KOJIAK` | DB Table | Service contract work order master table (サービス契約工事案件マスタ) — stores work order info linked to service contracts |
| `CD00577_AD_CHG_NEWESTA` | Constant | Work order type = "003" (住所変更(新設)) — Address Change with New Installation |
| `CD00577_NEWESTA` | Constant | Work order type = "007" (移設) — Relocation |
| `CD00474_CHUSHI` | Constant | Status = "900" (中止) — Cancelled |
| `CD00474_UK_ZM` | Constant | Status = "130" (受付済) — Acceptance Completed |
| `CD00474_TOROKU_ZM` | Constant | Status = "120" (登録済) — Registration Completed |
| `SVC_CD_NET` | Constant | Service code "01" (インターネットサービス) — Internet service |
| `SVC_CD_TEL` | Constant | Service code "02" (電話サービス) — Telephone service |
| `SVC_CD_TV` | Constant | Service code "03" (テレビサービス) — Television service |
| `ITNS_KOJIAK_NO_NET` | Field | Work order number for Net/TEL service (工事案件番号 NET/TEL) |
| `ITNS_KOJIAK_UPD_DTM_NET` | Field | Work order update date-time for Net/TEL (工事案件更新日時 NET/TEL) |
| `ITNS_KOJIAK_NO_TV` | Field | Work order number for TV service (工事案件番号 TV) |
| `ITNS_KOJIAK_UPD_DTM_TV` | Field | Work order update date-time for TV (工事案件更新日時 TV) |
| `OPMS_CHGE_RNKI_YH_NET` | Field | OPMS change linkage flag for Net/TEL (OPMS変更連携要否 NET) — "ON" means OPMS system linkage is required, "OFF" means it is not |
| `OPMS_CHGE_RNKI_YH_TV` | Field | OPMS change linkage flag for TV (OPMS変更連携要否 TV) — same semantics as NET variant |
| `ADCHG_FIX_DTM` | Field | Address change fix date-time (住所変更確定日時) — timestamp confirming the address change has been finalized |
| `KOJI_UK_OPTNTY_IDO_DTM` | Field | Work order relocation optional transfer date-time (工事移転要否移行日時) — timestamp used for optional relocation transfer operations |
| `CUR_KIHON_KOJIAK_NO_NET` | Field | Current basic work order number for Net/TEL (カレント基本工事案件番号 NET) — set only when no reserved service contract is attached to the work order |
| `CUR_KIHON_KOJIAK_UPD_DTM_NET` | Field | Current basic work order update date-time for Net/TEL (カレント基本工事案件更新日時 NET) |
| `CUR_KIHON_KOJIAK_NO_TV` | Field | Current basic work order number for TV (カレント基本工事案件番号 TV) |
| `CUR_KIHON_KOJIAK_UPD_DTM_TV` | Field | Current basic work order update date-time for TV (カレント基本工事案件更新日時 TV) |
| OPMS | Acronym | Operations and Maintenance Support System — external system for network operations management. The linkage flag indicates whether address change data should be synchronized to OPMS. |
| Net | Business term | K-Opticom Internet service (インターネットサービス), service code "01" |
| Tel | Business term | K-Opticom telephone service (電話サービス), service code "02" |
| TV | Business term | K-Opticom television service (テレビサービス), service code "03" |
| 工事案件 (Koji Ak) | Business term | Work order — a record representing a field work task (installation, change, relocation, etc.) in the telecom service fulfillment pipeline |
| 住所変更 (Juusho Henkou) | Business term | Address change — a service type where a customer's registered address is updated. This method handles confirmation/finalization of address changes. |
| 受付済 (Uketsuke-zumi) | Business term | Acceptance Completed — work order status "130", meaning the work order has been accepted and OPMS linkage may no longer be needed (flag OFF) |
| 中止 (Chuushi) | Business term | Cancelled — work order status "900", meaning the work order has been cancelled and should be excluded from processing |
| 基本工事案件 (Kihon Koji Ak) | Business term | Basic work order — the fundamental work order record associated with a service contract, used for tracking and flag management |
| 保留 (Horyou) | Business term | Reserved / Held — a service contract that is pending or reserved, preventing certain flag updates |
| existKojiAkTgSvcKei | Method | Reserved service contract check — returns true if a reserved service contract exists for the given work order number, false otherwise |