ADD_GPR_PSA_REFSΒΆ

Add new GPR-PSAGPR-Join.

Table: REDGPR.GPR_GPR_PSA_REFS (This table maps PSA and GPR table, if GPR data is not a fix value, but used from GPR table)

Parameter Name

Properties

Default Value

Parameter Description

p_gpr_config_id

(PK)(NN)

Foreign key to the GPR_CONFIG table

p_psa_table_id

(PK)(NN)

Reference to the GPR_PSA_TABLES

p_gpr_table_id

(PK)(NN)

Reference to the GPR_GPR_TABLES

p_psa_join_column

(PK)(NN)

Name of the join column in PSA object

p_gpr_join_column

(NN)

Name of the join column in GPR object

Example

EXECUTE SCRIPT api_redgpr.add_gpr_psa_refs
            ( 0          -- p_gpr_config_id
            , 0          -- p_psa_table_id
            , 0          -- p_gpr_table_id
            , 'XXX'      -- p_psa_join_column
            , 'XXX'      -- p_gpr_join_column
            );