Q1

-- Inserts for FHSA_BENEFICIARY columns (using REF_TABLE_ID = 40024 as example)

-- Column: PROVINCE_CODE
INSERT INTO TMCOLUMN (
    MAINTENANCE_TABLE_ID, COLUMN_NM, DESCRIPTION_TX, COLUMN_TYPE_CD, LOOKUP_NAME_TX,
    COLUMN_DISPLAY_ORDER, MIN_AT, MAX_AT, SOURCE_TABLE_NM, REQUIRED_FG, PART_OF_PK_FG,
    FORMAT_TX, RECORD_ORDER_AT, LANG_DEPT_FG
) VALUES (
    (SELECT REF_TABLE_ID FROM REF_TABLE WHERE REF_TABLE_NM = 'FHSA_BENEFICIARY'), -- Or use the ID directly: 40024
    'PROVINCE_CODE', 'Province Code', 'Normal', null, -- Assuming no specific lookup table
    1, 0, 2, 'FHSA_BENEFICIARY', 'Y', 'Y', -- Required=Y, Part of PK=Y
    'Text', null, 'F'
);

-- Column: PROVINCE_DESCRIPTION
INSERT INTO TMCOLUMN (
    MAINTENANCE_TABLE_ID, COLUMN_NM, DESCRIPTION_TX, COLUMN_TYPE_CD, LOOKUP_NAME_TX,
    COLUMN_DISPLAY_ORDER, MIN_AT, MAX_AT, SOURCE_TABLE_NM, REQUIRED_FG, PART_OF_PK_FG,
    FORMAT_TX, RECORD_ORDER_AT, LANG_DEPT_FG
) VALUES (
    (SELECT REF_TABLE_ID FROM REF_TABLE WHERE REF_TABLE_NM = 'FHSA_BENEFICIARY'),
    'PROVINCE_DESCRIPTION', 'Province Description', 'Normal', null,
    2, 0, 100, 'FHSA_BENEFICIARY', 'N', 'N', -- Not Required, Not PK
    'Text', null, 'F'
);

-- Column: BENEFICIARY_ALLOWED_FG
INSERT INTO TMCOLUMN (
    MAINTENANCE_TABLE_ID, COLUMN_NM, DESCRIPTION_TX, COLUMN_TYPE_CD, LOOKUP_NAME_TX,
    COLUMN_DISPLAY_ORDER, MIN_AT, MAX_AT, SOURCE_TABLE_NM, REQUIRED_FG, PART_OF_PK_FG,
    FORMAT_TX, RECORD_ORDER_AT, LANG_DEPT_FG
) VALUES (
    (SELECT REF_TABLE_ID FROM REF_TABLE WHERE REF_TABLE_NM = 'FHSA_BENEFICIARY'),
    'BENEFICIARY_ALLOWED_FG', 'Beneficiary Allowed (Y/N)', 'Normal', 'REFTABLEITEMSTATUS', -- Example: Using a common Y/N lookup if available
    3, 0, 1, 'FHSA_BENEFICIARY', 'Y', 'N', -- Required=Y (due to NOT NULL DEFAULT), Not PK
    'Text', null, 'F' -- Or maybe a specific lookup format if applicable
);

-- Column: SUCCESSOR_HOLDER_ALLOWED_FG
INSERT INTO TMCOLUMN (
    MAINTENANCE_TABLE_ID, COLUMN_NM, DESCRIPTION_TX, COLUMN_TYPE_CD, LOOKUP_NAME_TX,
    COLUMN_DISPLAY_ORDER, MIN_AT, MAX_AT, SOURCE_TABLE_NM, REQUIRED_FG, PART_OF_PK_FG,
    FORMAT_TX, RECORD_ORDER_AT, LANG_DEPT_FG
) VALUES (
    (SELECT REF_TABLE_ID FROM REF_TABLE WHERE REF_TABLE_NM = 'FHSA_BENEFICIARY'),
    'SUCCESSOR_HOLDER_ALLOWED_FG', 'Successor Holder Allowed (Y/N)', 'Normal', 'REFTABLEITEMSTATUS', -- Example
    4, 0, 1, 'FHSA_BENEFICIARY', 'Y', 'N',
    'Text', null, 'F'
);

-- Column: ACTIVE_FG
INSERT INTO TMCOLUMN (
    MAINTENANCE_TABLE_ID, COLUMN_NM, DESCRIPTION_TX, COLUMN_TYPE_CD, LOOKUP_NAME_TX,
    COLUMN_DISPLAY_ORDER, MIN_AT, MAX_AT, SOURCE_TABLE_NM, REQUIRED_FG, PART_OF_PK_FG,
    FORMAT_TX, RECORD_ORDER_AT, LANG_DEPT_FG
) VALUES (
    (SELECT REF_TABLE_ID FROM REF_TABLE WHERE REF_TABLE_NM = 'FHSA_BENEFICIARY'),
    'ACTIVE_FG', 'Active (Y/N)', 'Normal', 'REFTABLEITEMSTATUS', -- Example
    5, 0, 1, 'FHSA_BENEFICIARY', 'Y', 'N',
    'Text', null, 'F'
);

-- Column: UPDATED_BY (Often read-only in UI)
INSERT INTO TMCOLUMN (
    MAINTENANCE_TABLE_ID, COLUMN_NM, DESCRIPTION_TX, COLUMN_TYPE_CD, LOOKUP_NAME_TX,
    COLUMN_DISPLAY_ORDER, MIN_AT, MAX_AT, SOURCE_TABLE_NM, REQUIRED_FG, PART_OF_PK_FG,
    FORMAT_TX, RECORD_ORDER_AT, LANG_DEPT_FG
) VALUES (
    (SELECT REF_TABLE_ID FROM REF_TABLE WHERE REF_TABLE_NM = 'FHSA_BENEFICIARY'),
    'UPDATED_BY', 'Updated By', 'ReadOnly', null, -- Set as ReadOnly
    6, 0, 50, 'FHSA_BENEFICIARY', 'N', 'N',
    'Text', null, 'F'
);

-- Column: UPDATED_DATE (Often read-only in UI)
INSERT INTO TMCOLUMN (
    MAINTENANCE_TABLE_ID, COLUMN_NM, DESCRIPTION_TX, COLUMN_TYPE_CD, LOOKUP_NAME_TX,
    COLUMN_DISPLAY_ORDER, MIN_AT, MAX_AT, SOURCE_TABLE_NM, REQUIRED_FG, PART_OF_PK_FG,
    FORMAT_TX, RECORD_ORDER_AT, LANG_DEPT_FG
) VALUES (
    (SELECT REF_TABLE_ID FROM REF_TABLE WHERE REF_TABLE_NM = 'FHSA_BENEFICIARY'),
    'UPDATED_DATE', 'Updated Date', 'ReadOnly', null, -- Set as ReadOnly
    7, 0, 0, 'FHSA_BENEFICIARY', 'N', 'N', -- Max length 0 for timestamp/date often okay
    'Date', null, 'F' -- Or 'Timestamp' if that's a supported format
);

-- Make sure to use a unique REF_TABLE_ID and the correct LAST_REQUEST_ID
INSERT INTO REF_TABLE (
    REF_TABLE_ID, REF_TABLE_NM, REF_TABLE_DESCRIPTION_TX, LAST_REQUEST_ID,
    ACTIVE_FG, COMMON_FG, EDITABLE_FG
) VALUES (
    40024, -- Replace with actual unique ID
    'FHSA_BENEFICIARY',
    'FHSA Beneficiary Province Eligibility', -- Or a more suitable description
    'GOWDBR-XXX', -- Replace with your actual change/ticket ID
    'Y', -- Assuming it should be active
    'Y', -- Assuming common, adjust if needed
    'Y'  -- Assuming it should be editable via the UI
);