Table Detail Report

MM_CNTRCT_ORG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract Organization
Definition: Contract Organization
Table Type: REFERENCE





Column Detail - MM_CNTRCT_ORG


Column Name Type Null? Definition
CNTRCT_ID DOUBLE N Contract number key
ORGANIZATION_ID DOUBLE N organization identifier
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_CNTRCT_ORG


Child Column in MM_CNTRCT_ORG(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_CNTRCT_PRICE_ADJ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract Price Adjustment
Definition: Contract Price Adjustment
Table Type: REFERENCE





Column Detail - MM_CNTRCT_PRICE_ADJ


Column Name Type Null? Definition
ADJUSTMENT DOUBLE Y adjustment
ADJ_METRIC_CD DOUBLE N Adjustment metric code
ADJ_TYPE_CD DOUBLE N Adjustment type code value
CLASS_NODE_ID DOUBLE N Class Node ID value.
CNTRCT_ID DOUBLE N Contract number key
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who inserted the row in to the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
PRICE_ADJ_ID DOUBLE N price adjustment identifier
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_CNTRCT_PRICE_ADJ


Child Column in MM_CNTRCT_PRICE_ADJ(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID




Parent Column in MM_CNTRCT_PRICE_ADJ (PK) Child Table Name Child Column Name
Children: PRICE_ADJ_ID MM_XFI_CNTRCT_PRICE_ADJ PRICE_ADJ_ID


MM_CNTRCT_REBATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract Rebate
Definition: Contract Rebate
Table Type: REFERENCE





Column Detail - MM_CNTRCT_REBATE


Column Name Type Null? Definition
ACH_METRIC_CD DOUBLE N ACH Metric Code
ACH_THRESHOLD DOUBLE Y ACH threshold
CALC_ON_CD DOUBLE N Calculation on code
CNTRCT_ID DOUBLE N Contract number key
CREATE_APPLCTX DOUBLE Y Application which created this row
CREATE_DT_TM DATETIME Y The date and time when the row was inserted
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who inserted the row in to the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
PERIOD_CD DOUBLE N %etc
REBATE_ID DOUBLE N Rebate Identifier
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_CNTRCT_REBATE


Child Column in MM_CNTRCT_REBATE(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID




Parent Column in MM_CNTRCT_REBATE (PK) Child Table Name Child Column Name
Children: REBATE_ID MM_XFI_CNTRCT_REBATE REBATE_ID


MM_CNTRCT_SIGNATURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contract Signature
Definition: Contract Signature
Table Type: REFERENCE





Column Detail - MM_CNTRCT_SIGNATURE


Column Name Type Null? Definition
CNTRCT_ID DOUBLE N Contract number key
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SIGNATURE_ID DOUBLE N The Signature_Id identifies the electronic signature associated with this report section.
SIGNED_DT_TM DATETIME Y This indicated the date n time at which the document is signed.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_CNTRCT_SIGNATURE


Child Column in MM_CNTRCT_SIGNATURE(FK) Parent Table Name Parent Column Name
Parents: CNTRCT_ID MM_CNTRCT_HDR CNTRCT_ID


MM_XFI_CNTRCT_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM XFI CNTRCT ACTION
Definition: Table used to store relationships between contracts and action periods. Data is moved from this table to MM_CNTRCT_ACTION.
Table Type: REFERENCE





Column Detail - MM_XFI_CNTRCT_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y Action date/time
ACTION_FLAG DOUBLE Y Action flag for the action
ACTION_ID DOUBLE N action identifier
ACTION_PERIOD VARCHAR(60) Y Action period
ACTION_PERIOD_CD DOUBLE N Action period code value
ACTION_REASON VARCHAR(60) Y Action reason
ACTION_REASON_CD DOUBLE N Action reason code value
ACTION_USER VARCHAR(60) Y Action user
ACTION_USER_ID DOUBLE N Action user key
CONTRIBUTOR_CD DOUBLE N Contributor Source Code value
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the record was created
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
PROCESS_FLAG DOUBLE Y process flag
TRANSACTION_ID DOUBLE N Primary key
TRANS_PARENT_ID DOUBLE N transaction parent identifier
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MM_XFI_CNTRCT_ACTION


Child Column in MM_XFI_CNTRCT_ACTION(FK) Parent Table Name Parent Column Name
Parents: ACTION_ID MM_CNTRCT_ACTION ACTION_ID
TRANS_PARENT_ID MM_XFI_CNTRCT_HDR TRANSACTION_ID
ACTION_USER_ID PRSNL PERSON_ID