ADD_BK_PSA_REFS

Add new GPR-BK PSA Refs.

Table: REDGPR.GPR_BK_PSA_REFS (This table maps business keys to PSA master columns)

Parameter Name	Properties	Default Value	Parameter Description
p_gpr_config_id	(PK)(NN)		Foreign key to the GPR_CONFIG table
p_bk_schema_name	(PK)(NN)		Name of the schema where the business key table is stored
p_bk_table_name	(PK)(NN)		Name of the business key table
p_bk_join_column	(PK)(NN)		Name of the business key column
p_psa_master_col_name	(NN)		Name of the corresponding PSA master column

Example

EXECUTE SCRIPT api_redgpr.add_bk_psa_refs
            ( 0                 -- p_gpr_config_id
            , 'XXX'             -- p_bk_schema_name
            , 'XXX'             -- p_bk_table_name
            , 'XXX'             -- p_bk_join_column
            , 'XXX'             -- p_psa_master_col_name
            );