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 );

Apr 25, 2025 - 05:51


-- 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
);