May 6, 2008 at 2:47 pm
Hello ALL,
I need help creating an UPDATE statement.
I have somthing directly below, but it does not do what I would like it to do. ( create table and INSERT stmts are below)
--------------------------------------------------------------------------------
UPDATE
WORKTBL
SET
TB_DESC =
(SELECT
T2.PARENT_COLUMN
FROM
WORKTBL T1
INNER JOIN CHILD_PARENT T2
ON WORKTBL.COLUMN_NAME = T2.PARENT_COLUMN
WHERE
WORKTBL.COLUMN_NAME = T2.PARENT_COLUMN
GROUP BY
T2.PARENT_COLUMN )
WHERE
WORKTBL.tb_desc IS NULL ;
GO
-- HOW DO I WRITE THE ABOVE UPDATE stmt so that???
-- I want WORKTBL.tb_desc to be updated to the value in CHILD_PARENT.parent_colum
-- if it is NOT NULL
-- mutiple rec mathes may be an issue so the Group By my be important here
SELECT * FROM WORKTBL WHERE COLUMN_NAME LIKE '%FY_CD_%';
TABLE_NAME COLUMN_NAME TB_DESC
------------- -------------- ----------
ACCT FY_CD_FR (null)
ACCT FY_CD_TO (null)
SELECT * FROM CHILD_PARENT WHERE CHILD_COLUMN = 'FY_CD_FR'
CHILD_NAME CHILD_COLUMN PARENT_NAME PARENT_COLUMN
------------- --------------- -------------- ----------------
ACCT FY_CD_FR ACCTING_PD FY_CD
---------------------------------------------------------------------------------
[b]Scripts for tbl Env[/b]
CREATE TABLE WORKTBL (
TABLE_NAME sysname NOT NULL,
COLUMN_NAMEsysname NOT NULL,
TB_DESC varchar(255) NULL
)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ACCT', 'FY_CD_FR', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ACCT', 'FY_CD_TO', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ACCT_PD_TRNSL', 'ALT_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ACCT_PD_TRNSL', 'ALT_FY_TYPE_DC', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ACCT_PD_TRNSL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ACCTING_PD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ALLOC_APPLIC', 'APPL_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ALLOC_BASIS_JNL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ALLOC_BASIS_JNL_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ALT_FY', 'ALT_FY_CD', 'ALT_FY')
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ALT_FY', 'ALT_FY_TYPE_DC', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ALT_FY_TYPE_DC', 'ALT_FY_TYPE_DC', 'ALT_FY_TYPE_DC')
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAM_INP_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAM_INP_HDR', 'CHK_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAM_INP_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAM_INP_LAB', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAP_INP_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAP_INP_HDR', 'CHK_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAP_INP_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLAP_INP_LAB', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLJE_INP_EMP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLJE_INP_TR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AOPUTLJE_INP_VEN', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AP_UNREAL_G_L_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AP_UNREAL_G_L_HS', 'RVRS_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AR_DETL_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AR_FIN_CHARGE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AR_UNREAL_G_L_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AR_UNREAL_G_L_HS', 'RVRS_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ASSET', 'ACQ_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ASSET', 'DISP_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ASSET_AUDIT_LOG', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ASSET_AUDIT_LOG', 'POST_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('AUTOCR_ASSET_EDIT', 'ACQ_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BANK_ACCT_END_BAL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BANK_ACCT_STMT_DTL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BANK_TRN_HS', 'BANK_ACCPT_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BANK_TRN_HS', 'TRN_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BILL_EDIT_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BILL_EDIT_INVC_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BILL_FRMT_LN_ACCT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BILL_INVC_HDR_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BILL_SCHEDULE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BILLING_DETL_HIST', 'POST_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BILLING_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BUD_ALLOC_APPLIC', 'APPL_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BUD_COMP_BURD', 'APPL_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('BURD_TEMP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CASH_DISB_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CASH_RECPT_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CASH_RECPT_HDR_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CB_BURD_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CB_SETTINGS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CB_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CEIL_BURDEN_CST', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CFLOW_DISCLOSE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CO_PAID_MATCH', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CO_PAID_MATCH_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CO_PAID_MATCH_HS', 'MATCH_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CONS_LINK_LOC_PCT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CONS_PSR_FINAL_DAT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CONS_PSR_FN_DT_IMP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CONS_PSR_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CONS_PSR_HDR_IMP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CONS_RPT_REV_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CONS_RPT_RV_SM_IMP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('CYCLE_RULE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_CNTRB_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_CNTRB_PROJ', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_DED_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_DED_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_DED_GARN', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_DED_GRN_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_FRNG_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_LOCAL_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_PAY_TP_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_PROJ', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_PT_PROJ', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_STATE_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_WC_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_E_WC_PROJ', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_CNTRB', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_DD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_DED', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_LOCAL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_PAY_TYPE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_ST_C_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_ST_CODE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_STATE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_TS_INFO', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARN_WC', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_EARNINGS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_LV_HIST', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_LV_JNL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_PAYROLL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('EMPL_PAYROLL_ADT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ERMS_TIMESHEET', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ETC_IND_CST', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ETC_UPD_DT', 'INC_AMT_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ETC_UPD_DT', 'INC_GLC_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ETC_UPD_DT', 'INC_PLC_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_DEPR_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_FY_INFO', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_PD_INFO', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_POSTING_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_PRJTD_DISP', 'DISP_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_PRJTD_PURCHASE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_SETTINGS', 'CUR_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FA_TMPLT_AUDIT_LOG', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FS_LN_CFLOW_ADJ', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FS_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('FY', 'FY_CD', 'FY')
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('GL_BUD_RVSN', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('GL_POST_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('HS_ORG_BUD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('HS_ORG_BUD_BY_CP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('HS_ORG_BUD_BY_EMPL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ICR_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ICR_HDR_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('INVT_BURD_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('INVT_BURD_SUM_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('INVT_SETTINGS', 'LAST_CLOSE_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('INVT_TRN', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('INVT_TRN_STATUS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('IWO_ALLOC_TRN', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('IWO_ALLOC_TRN_SUSP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('IWO_CREATION_ERROR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('IWO_PY_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('JE_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('JE_HDR_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('JE_RVRS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('JNL_STATUS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('LAB_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('LAST_JE_NO', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('MANUAL_BILL_EDIT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('MANUAL_BILL_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('MO_HDR', 'VAR_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('MO_HDR_CST', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('NASA_FM_LN_ACCT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('NASA_FY', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('NASA_FY', 'NASA_FY_CD', 'NASA_FY')
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('NASA_PD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('OPEN_BILLING_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ORG', 'FY_CD_FR', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ORG', 'FY_CD_TO', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ORG_ACCT', 'FY_CD_FR', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ORG_ACCT', 'FY_CD_TO', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ORG_ACCT_BUD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('ORG_HIST', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('OTH_FEE_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('OVRIDE_FEE_ON_BURD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PLAN_RATING_BY_GRD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PO_ACCRL_LOG', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PO_ACCRL_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PO_COMMIT_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PO_COMMIT_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_ALLOC', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_BASE_ACCT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_BASE_WILDCARD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_COST_ACCT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_COST_WILDCARD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_INFO', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_RT_TABLE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_SIE_SUPPORT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POOL_VAR_ACCT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POST_SEMAPHORE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('POSTING', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PRG_PMT_DETL_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PRG_PMT_EDIT_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PRG_PMT_EDIT_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PRG_PMT_HDR_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PRG_PMT_SUBC_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_ACRN_HDR_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_ALLOC_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_ALLOC_LAB_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BILL_HS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_DIR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_FEE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_GLC', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_IND', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_PLC', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_PRD_REP', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_RVSN', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUD_UNITS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_DAYS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_DIRECT', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_FEE', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_INDIR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_INFO', 'UPD_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_LABOR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BUDGET_UNITS', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_BURD_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_CSSR_BUD', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_GOAL_DETL', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_GOAL_HDR', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_GOAL_UNBILL', 'TRN_FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_SUM', 'FY_CD', NULL)
GO
INSERT INTO WORKTBL(TABLE_NAME, COLUMN_NAME, TB_DESC)
VALUES('PROJ_TOT_BUD_IND', 'FY_CD', NULL)
GO
CREATE TABLE CHILD_PARENT (
CHILD_NAME varchar(18) NULL,
CHILD_COLUMN varchar(18) NULL,
PARENT_NAME varchar(18) NULL,
PARENT_COLUMNvarchar(18) NULL
)
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT', 'FY_CD_FR', 'ACCTING_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT', 'FY_CD_TO', 'ACCTING_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT', 'S_ACCT_TYPE_CD', 'S_ACCT_TYPE', 'S_ACCT_TYPE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT_ENTRY_RULES', 'ACCT_ENTR_GRP_CD', 'ACCT_ENTR_GRP',
'ACCT_ENTR_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT_ENTRY_RULES', 'S_ACCT_ENTR_SCR_CD', 'S_ACCT_ENTRY_SCR',
'S_ACCT_ENTR_SCR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT_GRP_SETUP', 'ACCT_GRP_CD', 'ACCT_GRP_CD', 'ACCT_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT_GRP_SETUP', 'S_ACCT_FUNC_DC', 'S_ACCT_FUNC',
'S_ACCT_FUNC_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT_PD_TRNSL', 'ALT_FY_CD', 'ALT_FY', 'ALT_FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT_PD_TRNSL', 'ALT_FY_TYPE_DC', 'ALT_FY', 'ALT_FY_TYPE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCT_PD_TRNSL', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ACCTING_PD', 'FY_CD', 'FY', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL', 'FY_CD', 'POOL_ALLOC', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL', 'FY_CD', 'POSTING', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL', 'S_JNL_CD', 'POSTING', 'S_JNL_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL_HS', 'FY_CD', 'POSTING', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL_HS', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL_HS', 'FY_CD', 'POOL_ALLOC', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALLOC_BASIS_JNL_HS', 'S_JNL_CD', 'POSTING', 'S_JNL_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ALT_FY', 'ALT_FY_TYPE_DC', 'ALT_FY_TYPE_DC',
'ALT_FY_TYPE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AMORT_SCH_PD', 'AMORT_CD', 'AMORT_SCH', 'AMORT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('APPRVL_PROC_TITLE', 'RQ_APPR_TITLE_DC', 'RQ_APPRVL_TITLE',
'RQ_APPR_TITLE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AR_DETL_HS', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AR_DETL_HS', 'SALES_TAX_CD', 'SALES_TAX', 'SALES_TAX_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AR_HDR_HS', 'ADDR_DC', 'CUST_ADDR', 'ADDR_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AR_HDR_HS', 'BILL_PMT_ADDR_CD', 'BILL_PAYMENT_ADDR',
'BILL_PMT_ADDR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AR_HDR_HS', 'BILL_RMT_ADDR_CD', 'BILL_REMIT_ADDR',
'BILL_RMT_ADDR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AR_SALES_TAX', 'SALES_TAX_CD', 'SALES_TAX', 'SALES_TAX_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'ACCUM_DEPR_ACCT_CD', 'ACCUM_DEPR_ACCT',
'ACCUM_DEPR_ACCT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'B1_DEPR_MTHD_CD', 'DEPR_MTHD', 'DEPR_MTHD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'DEPR_EXP_ALC_CD', 'DEPR_EXP_ALLOC_CD',
'DEPR_EXP_ALC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'FA_CLASSIF_CD', 'FA_CLASSIF_CD', 'FA_CLASSIF_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'FA_LOC1_CD', 'FA_LOCATION', 'FA_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'FA_LOC2_CD', 'FA_LOCATION', 'FA_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'FA_LOC3_CD', 'FA_LOCATION', 'FA_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'FA_SUBCLASS_CD', 'FA_SUBCLASS_CD', 'FA_SUBCLASS_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET', 'MAIL_STATE_DC', 'MAIL_STATE', 'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ASSET_AUDIT_LOG', 'FY_CD', 'FA_PD_INFO', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AUTOCR_ASSET_EDIT', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AUTOCR_ASSET_EDIT', 'FA_LOC_GRP_CD', 'FA_LOCATION_GRP',
'FA_LOC_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AUTOCR_ASSET_EDIT', 'FA_LOC1_CD', 'FA_LOCATION', 'FA_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AUTOCR_ASSET_EDIT', 'FA_LOC2_CD', 'FA_LOCATION', 'FA_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AUTOCR_ASSET_EDIT', 'FA_LOC3_CD', 'FA_LOCATION', 'FA_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AUTOCR_ASSET_EDIT', 'FA_SUBCLASS_CD', 'FA_SUBCLASS_CD',
'FA_SUBCLASS_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('AUTOCR_ASSET_EDIT', 'MAIL_STATE_DC', 'MAIL_STATE',
'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BANK_ACCT_END_BAL', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BANK_ACCT_STMT_DTL', 'FY_CD', 'BANK_ACCT_END_BAL', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_EDIT_INVC_HDR', 'BILL_RMT_ADDR_CD', 'BILL_REMIT_ADDR',
'BILL_RMT_ADDR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_EDIT_INVC_HDR', 'CUST_ADDR_DC', 'CUST_ADDR', 'ADDR_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_EDIT_INVC_HDR', 'OTH_CHG_CD1', 'BILL_OTH_CHGS',
'OTH_CHG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_EDIT_INVC_HDR', 'OTH_CHG_CD2', 'BILL_OTH_CHGS',
'OTH_CHG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_EDIT_INVC_HDR', 'OTH_CHG_CD3', 'BILL_OTH_CHGS',
'OTH_CHG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_FRMT', 'BILL_STD_TEXT_CD', 'BILL_STD_TEXT',
'BILL_STD_TEXT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_FRMT_LN', 'BILL_FRMT_CD', 'BILL_FRMT', 'BILL_FRMT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_FRMT_LN_ACCT', 'BILL_FRMT_CD', 'BILL_FRMT_LN',
'BILL_FRMT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_FRMT_LN_ACCT', 'FY_CD', 'POOL_ALLOC', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_GRP_USERS', 'BILL_GRP_CD', 'BILL_GRP', 'BILL_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_PAYMENT_ADDR', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_PAYMENT_ADDR', 'MAIL_STATE_DC', 'MAIL_STATE',
'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_REMIT_ADDR', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_REMIT_ADDR', 'MAIL_STATE_DC', 'MAIL_STATE',
'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_SCHEDULE', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_SETTINGS', 'DFLT_BILL_CYCLE_CD', 'BILL_CYCLE',
'BILL_CYCLE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_SETTINGS', 'DFLT_PRC_CATLG_CD', 'PRICE_CATLG',
'PRICE_CATLG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_SETTINGS', 'DFLT_RMT_ADDR_CD', 'BILL_REMIT_ADDR',
'BILL_RMT_ADDR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BILL_SETTINGS', 'DFLT_SALES_TAX_CD', 'SALES_TAX',
'SALES_TAX_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BRNCH_ADDR', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BRNCH_ADDR', 'MAIL_STATE_DC', 'MAIL_STATE', 'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BRNCH_ADDR_CNTACT', 'ADDR_DC', 'BRNCH_ADDR', 'ADDR_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BUD_CO_HDR', 'BUD_CO_STAT_CD', 'BUD_CO_STATUS',
'BUD_CO_STAT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BUD_CO_LN_HRS', 'BILL_LAB_CAT_CD', 'BILL_LAB_CAT',
'BILL_LAB_CAT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('BUD_CO_LN_HRS', 'GENL_LAB_CAT_CD', 'GENL_LAB_CAT',
'GENL_LAB_CAT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CASH_RECPT_HDR', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CASH_RECPT_HDR', 'FY_CD', 'POSTING', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CASH_RECPT_HDR', 'S_JNL_CD', 'POSTING', 'S_JNL_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CASH_RECPT_HDR_HS', 'FY_CD', 'POSTING', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CASH_RECPT_HDR_HS', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CASH_RECPT_HDR_HS', 'S_JNL_CD', 'POSTING', 'S_JNL_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CEIL_BURDEN_CST', 'FY_CD', 'POOL_ALLOC', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CEIL_DIR_HRS', 'BILL_LAB_CAT_CD', 'BILL_LAB_CAT',
'BILL_LAB_CAT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CFLOW_DISCLOSE', 'FS_CD', 'FS', 'FS_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CFT_CASH_ACCTS', 'TMPLT_CD', 'CFT_TMPLT', 'TMPLT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CFT_RPT_ADJ', 'TMPLT_CD', 'CFT_TMPLT_LN', 'TMPLT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CFT_RPT_DETL', 'CFT_FREQ_CD', 'CFT_RPT_HDR', 'CFT_FREQ_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CFT_RPT_DETL', 'TMPLT_CD', 'CFT_RPT_HDR', 'TMPLT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CFT_TMPLT_LN', 'TMPLT_CD', 'CFT_TMPLT', 'TMPLT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CFT_TMPLT_LN_ACCT', 'TMPLT_CD', 'CFT_TMPLT_LN', 'TMPLT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CHILD_SUP_GARN_SET', 'STATE_CD', 'STATE', 'STATE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CNTRB_MATCH_RT', 'DED_CD', 'DED_CD_CORP', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CO_PAID_MATCH', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CO_PAID_MATCH', 'TRANSP_CD', 'TRANSP_CD', 'TRANSP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COMM', 'IND_CLASS_CD', 'IND_CLASS', 'IND_CLASS_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COMP_PLAN_DFLT', 'COMP_PLAN_CD', 'COMP_PLAN_SETUP',
'COMP_PLAN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COMP_PLAN_DFLT', 'LAB_LOC_CD', 'LAB_LOCATION', 'LAB_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COMP_PLAN_HDR', 'COMP_PLAN_CD', 'COMP_PLAN_SETUP',
'COMP_PLAN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COMP_PLAN_LN', 'COMP_PLAN_CD', 'COMP_PLAN_HDR',
'COMP_PLAN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COMP_PLAN_LN', 'SAL_GRADE_CD', 'SALARY_GRADES',
'SAL_GRADE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COMP_SETTINGS', 'DFLT_COMP_PLAN_CD', 'COMP_PLAN_SETUP',
'COMP_PLAN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONS_AO_LOOKUP', 'CONS_MAP_CD', 'CONS_MAP_WILDCARD',
'CONS_MAP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONS_HDR_SUSP', 'RCV_LOC_CD', 'IWO_LOCATIONS', 'IWO_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONS_HDR_SUSP', 'SEND_LOC_CD', 'IWO_LOCATIONS', 'IWO_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONS_LINK_LOC_MAP', 'CONS_MAP_CD', 'CONS_MAPPING',
'CONS_MAP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONS_LINK_LOC_MAP', 'RCV_LOC_CD', 'IWO_LOCATIONS',
'IWO_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONS_MAP_WILDCARD', 'CONS_MAP_CD', 'CONS_MAPPING',
'CONS_MAP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONTR_ADDR', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CONTR_ADDR', 'MAIL_STATE_DC', 'MAIL_STATE', 'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COURT_REMIT', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('COURT_REMIT', 'MAIL_STATE_DC', 'MAIL_STATE', 'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CRDT_DBT_GARN_SET', 'STATE_CD', 'STATE', 'STATE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CREW_TS_LN', 'FRINGE_CD', 'FRINGE_CD', 'FRINGE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CREW_TS_LN', 'S_TS_LN_TYPE_CD', 'S_TS_LINE_TYPE',
'S_TS_LN_TYPE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CREW_TS_LN', 'S_TS_TYPE_CD', 'CREW_TS_HDR', 'S_TS_TYPE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CREW_TS_LN', 'TS_PD_CD', 'TS_PD', 'TS_PD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CREW_TS_LN', 'WH_STATE_CD', 'STATE', 'STATE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CREW_TS_LN', 'WORK_COMP_CD', 'WORK_COMP', 'WORK_COMP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CREW_TS_LN', 'WORK_STATE_CD', 'STATE', 'STATE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CTS_CLIENT_MAP', 'PAY_PD_CD', 'PAY_PD', 'PAY_PD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST', 'BILL_PMT_ADDR_CD', 'BILL_PAYMENT_ADDR',
'BILL_PMT_ADDR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST', 'CUST_TYPE_DC', 'CUST_TYPE', 'CUST_TYPE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST', 'ISSUE_BY_ADDR_CD', 'ISSUE_BY_ADDR',
'ISSUE_BY_ADDR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST', 'PRICE_CATLG_CD', 'PRICE_CATLG', 'PRICE_CATLG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST', 'SALES_ABBRV_CD', 'SALES_ABBRV_CD', 'SALES_ABBRV_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_ADDR', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_ADDR', 'MAIL_STATE_DC', 'MAIL_STATE', 'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_ADDR', 'SALES_TAX_CD', 'SALES_TAX', 'SALES_TAX_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_ADDR_CNTACT', 'ADDR_DC', 'CUST_ADDR', 'ADDR_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_PROD_INVC_HDR', 'BILL_RMT_ADDR_CD', 'BILL_REMIT_ADDR',
'BILL_RMT_ADDR_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_PROD_INVC_HDR', 'OTH_CHG_CD1', 'BILL_OTH_CHGS',
'OTH_CHG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_PROD_INVC_HDR', 'OTH_CHG_CD2', 'BILL_OTH_CHGS',
'OTH_CHG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_PROD_INVC_HDR', 'OTH_CHG_CD3', 'BILL_OTH_CHGS',
'OTH_CHG_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_PROD_INVC_HDR', 'SALES_ABBRV_CD', 'SALES_ABBRV_CD',
'SALES_ABBRV_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUST_PROD_INVC_LN', 'SALES_TAX_CD', 'SALES_TAX',
'SALES_TAX_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUSTOM_TBLWIN', 'S_MODULE_CD', 'S_APPL_FUNC', 'S_MODULE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CUSTOM_TBLWIN_COL', 'S_MODULE_CD', 'CUSTOM_TBLWIN',
'S_MODULE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CYCLE_RULE', 'CYCLE_DC', 'CYCLE', 'CYCLE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('CYCLE_RULE', 'FY_CD', 'SUB_PD', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DED_CD_CORP', 'CNTRB_DED_MOD_CD', 'DED_MOD', 'DED_MOD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DED_CD_CORP', 'DED_MOD_CD', 'DED_MOD', 'DED_MOD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DED_CD_CORP', 'WORK_COMP_CD', 'WORK_COMP', 'WORK_COMP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DED_MOD_PAY_TYPE', 'DED_MOD_CD', 'DED_MOD', 'DED_MOD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DED_SCH_LN', 'DED_CD', 'DED_CD_CORP', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DED_SCH_LN', 'DED_SCH_CD', 'DED_SCH', 'DED_SCH_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DEPR_MTHD_YRS', 'DEPR_MTHD_CD', 'DEPR_MTHD', 'DEPR_MTHD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DETL_JOB_TITLES', 'FUNC_JOB_CD', 'FUNC_JOB_TITLES',
'FUNC_JOB_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DFLT_OT_TS', 'LAB_LOC_CD', 'LAB_LOCATION', 'LAB_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DFLT_OT_TS', 'WORK_COMP_CD', 'WORK_COMP', 'WORK_COMP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DFLT_REG_TS', 'LAB_LOC_CD', 'LAB_LOCATION', 'LAB_LOC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DFLT_REG_TS', 'WORK_COMP_CD', 'WORK_COMP', 'WORK_COMP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DISP_INC_DED', 'DED_CD', 'DED_CD_CORP', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DISP_INC_SETUP', 'STATE_CD', 'STATE', 'STATE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DOC_TYPE', 'DOC_MEDIA_CD', 'DOC_MEDIA', 'DOC_MEDIA_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DOC_TYPE', 'DOC_SIZE_CD', 'DOC_SIZE', 'DOC_SIZE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DOC_TYPE', 'MAINT_GRP_CD', 'MAINT_GRP', 'MAINT_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DOCUMENT', 'DOC_MEDIA_CD', 'DOC_MEDIA', 'DOC_MEDIA_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DOCUMENT', 'DOC_TYPE_CD', 'DOC_TYPE', 'DOC_TYPE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('DOCUMENT', 'MAINT_GRP_CD', 'MAINT_GRP', 'MAINT_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_APP_PROC_TITLE', 'EC_APP_PROC_CD', 'EC_APP_PROC',
'EC_APP_PROC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_APP_PROC_TITLE', 'EC_APP_TITLE_DC', 'EC_APP_TITLE',
'EC_APP_TITLE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_APP_TITLE_USER', 'EC_APP_TITLE_DC', 'EC_APP_TITLE',
'EC_APP_TITLE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_APP_TTL_USR_PRJ', 'EC_APP_TITLE_DC', 'EC_APP_TITLE_USER',
'EC_APP_TITLE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_COUNTRY', 'COUNTRY_CD', 'COUNTRY', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_TYPE', 'EC_APP_PROC_CD', 'EC_APP_PROC', 'EC_APP_PROC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_TYPE', 'RSN_CD', 'RSN_CD', 'RSN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_TYPE', 'S_RSN_WH_USED_CD', 'RSN_CD', 'S_RSN_WH_USED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EC_TYPE_IMPACT_GRP', 'IMPACT_GRP_CD', 'IMPACT_GRP',
'IMPACT_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN', 'CUST_ADDR_DC', 'CUST_ADDR', 'ADDR_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN', 'EC_APP_PROC_CD', 'EC_APP_PROC', 'EC_APP_PROC_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN', 'EC_REASON_CD', 'EC_RSN', 'EC_RSN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN', 'RSN_CD', 'RSN_CD', 'RSN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN', 'S_RSN_WH_USED_CD', 'RSN_CD', 'S_RSN_WH_USED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN_APPRVL', 'EC_APPRVL_TITLE_DC', 'EC_APP_TITLE',
'EC_APP_TITLE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN_APPRVL', 'RSN_CD', 'RSN_CD', 'RSN_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN_APPRVL', 'S_RSN_WH_USED_CD', 'RSN_CD',
'S_RSN_WH_USED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN_DOCUMENT', 'DOC_MEDIA_CD', 'DOC_MEDIA', 'DOC_MEDIA_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN_DOCUMENT', 'DOC_SIZE_CD', 'DOC_SIZE', 'DOC_SIZE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN_DOCUMENT', 'MAINT_GRP_CD', 'MAINT_GRP', 'MAINT_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('ECN_IMPACT_GRP', 'IMPACT_GRP_CD', 'IMPACT_GRP',
'IMPACT_GRP_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL', 'COUNTRY_CD', 'MAIL_STATE', 'COUNTRY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL', 'LV_PD_CD', 'LV_PD', 'LV_PD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL', 'MAIL_STATE_DC', 'MAIL_STATE', 'MAIL_STATE_DC')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL', 'S_ESS_COS_CD', 'S_ESS_COS_CD', 'S_ESS_COS_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL', 'TS_PD_CD', 'TS_PD', 'TS_PD_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL', 'VISA_TYPE_CD', 'VISA_TYPE', 'VISA_TYPE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_ALLOW_CD', 'ALLOWANCE_CD', 'ALLOWANCE_CD',
'ALLOWANCE_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_BOND_HDR2', 'DED_CD', 'DED_CD_CORP', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_BOND_LN2', 'DED_CD', 'EMPL_BOND_HDR2', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_CEIL', 'BILL_LAB_CAT_CD', 'BILL_LAB_CAT',
'BILL_LAB_CAT_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_CNTRB', 'CNTRB_DED_CD', 'DED_CD_CORP', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_DED', 'DED_CD', 'DED_CD_CORP', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_DRUG_TEST', 'DRUG_TEST_CD', 'DRUG_TEST', 'DRUG_TEST_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_CNTRB_PROJ', 'CNTRB_DED_CD', 'EMPL_EARN_CNTRB',
'CNTRB_DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_CNTRB_PROJ', 'FY_CD', 'EMPL_EARN_CNTRB', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_DED_DETL', 'DED_CD', 'EMPL_EARN_DED', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_DED_DETL', 'FY_CD', 'EMPL_EARN_DED', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_DED_GARN', 'DED_CD', 'EMPL_EARN_DED', 'DED_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_DED_GARN', 'FY_CD', 'EMPL_EARN_DED', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_FRNG_DETL', 'FY_CD', 'EMPL_EARNINGS', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_PROJ', 'FY_CD', 'EMPL_EARNINGS', 'FY_CD')
GO
INSERT INTO CHILD_PARENT(CHILD_NAME, CHILD_COLUMN, PARENT_NAME,
PARENT_COLUMN)
VALUES('EMPL_E_PT_PROJ', 'FY_CD', 'EMPL_EARN_PAY_TYPE', 'FY_CD')
GO
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply