RC_SLA_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Service Level Agreement Activity
Definition: Holds reported SLA scheduling activity.
Table Type: ACTIVITY





Column Detail - RC_SLA_ACTIVITY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
HEALTH_PLAN_ID DOUBLE N Uniquely identifies the related Health Plan of the SLA.
RC_SLA_ACTIVITY_ID DOUBLE N Unique generated number that identifies a single row on the RC_SLA_ACTIVITY table.
SCH_EVENT_ID DOUBLE N Uniquely identifies the scheudling event related to this activity.
SLA_UNIT_CD DOUBLE N Identifies the units for this SLA value
SLA_VALUE DOUBLE N Contains the value of the SLA.
SUBMIT_AUTH_BY_DT_TM DATETIME Y The date by which the SLA must be authorized.
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 - RC_SLA_ACTIVITY


Child Column in RC_SLA_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID


SCH_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Actions
Definition: Holds the actions for the applied default schedules.
Table Type: ACTIVITY





Column Detail - SCH_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Scheduling Action Data and Time
ACTION_MEANING VARCHAR(12) N A 12-char description corresponding to the Scheduling ActionCode.
ACTION_PRSNL_ID DOUBLE N Action Personnel Identifier
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
CONVERSATION_ID DOUBLE N ID for the conversation that the action is relevant to. This identifier is used to track all the actions to be performed at the same transaction. This field makes debugging much easier.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PARENT_ID DOUBLE N The unique identifier of the parent object.
PARENT_ID2 DOUBLE Y The unique identifier of the parent object.
PARENT_TABLE VARCHAR(32) Y The parent table in the name of the table that Parent _id is from.
PERFORM_DT_TM DATETIME N The performed date and time specified by the user that the action was performed. It is used for retroactive checkin.
REASON_MEANING VARCHAR(12) Y A 12-character description corresponding to the scheduling reason.
SCH_ACTION_CD DOUBLE N A unique identifier for the Scheduling Action Code
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SCH_REASON_CD DOUBLE N The coded identifier of the scheduling reason.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_ACTION


Child Column in SCH_ACTION(FK) Parent Table Name Parent Column Name
Parents: SCH_ACTION_CD CODE_VALUE CODE_VALUE
SCH_REASON_CD CODE_VALUE CODE_VALUE
ACTION_PRSNL_ID PRSNL PERSON_ID




Parent Column in SCH_ACTION (PK) Child Table Name Child Column Name
Children: SCH_ACTION_ID SCH_FREQ_DATE SCH_ACTION_ID


SCH_ACTION_DATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Action Date
Definition: Stores scheduling request date ranges for a given scheduling request.
Table Type: ACTIVITY





Column Detail - SCH_ACTION_DATE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_DT_TM DATETIME N Begin Date and Time value
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
DAYS_OF_WEEK VARCHAR(10) N A 7-char string representing the days of the week.
END_DT_TM DATETIME N End Date and Time value
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
SCENARIO_NBR DOUBLE N Sequence number to distinguish a scenario of scheduling request date range.
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SEQ_NBR DOUBLE N Determines the order among the children of a group.
TIME_RESTR_CD DOUBLE N Time restriction code - AM, PM only etc, from code set 16153.
TIME_RESTR_MEANING VARCHAR(12) Y A 12-character description corresponding to the TIME_RESTR_CD
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_ACTION_DATE


Child Column in SCH_ACTION_DATE(FK) Parent Table Name Parent Column Name
Parents: TIME_RESTR_CD CODE_VALUE CODE_VALUE
SCH_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID


SCH_ACTION_LINK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Store the relationship between a Scheduling Event Action and an Appointment
Definition: Scheduling Action Link
Table Type: ACTIVITY





Column Detail - SCH_ACTION_LINK


Column Name Type Null? Definition
ACTION_MEANING VARCHAR(12) N A 12-char description corresponding to the Scheduling ActionCode.
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PARENT2_ID DOUBLE N Parent2 Identifier
PARENT2_TABLE VARCHAR(32) N Parent2 Table
PARENT_ID DOUBLE N Parent Identifier
PARENT_TABLE VARCHAR(32) N Parent Table
SCH_ACTION_CD DOUBLE N A unique identifier for the Scheduling Action Code
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.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_ACTION_LINK


Child Column in SCH_ACTION_LINK(FK) Parent Table Name Parent Column Name
Parents: SCH_ACTION_CD CODE_VALUE CODE_VALUE


SCH_ACTION_LOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scheduling Request Locations
Definition: Scheduling Request Locations
Table Type: ACTIVITY





Column Detail - SCH_ACTION_LOC


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CANDIDATE_ID DOUBLE N A sequence-generated number to uniquely identify the specific row in the database.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient.
LOCATION_SEQ_NBR DOUBLE Y This one-based sequence number is used to provide an order (1st, 2nd, 3rd, etc.) between the possible appointment locations for a scheduling request.
LOCATION_TYPE_CD DOUBLE N Defines the locations meaning to scheduling.
LOCATION_TYPE_MEANING VARCHAR(12) Y A 12-char description of the location's meaning to scheduling.
NULL_DT_TM DATETIME N contains 31-DEC-2100 00:00:00.00
PARENT_SEQ_NBR DOUBLE Y This field allows the appointment location list for a protocol component to flex based on the protocol parent's location list for a scheduling request.
SCENARIO_NBR DOUBLE N Scenario Number
SCH_ACTION_ID DOUBLE N The identifier to uniquely identify the action being performed.
SEQ_NBR DOUBLE N Determines the order among the children of a group.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VERSION_DT_TM DATETIME N The version date and time marks the date the record became historical.



Relationship Detail - SCH_ACTION_LOC


Child Column in SCH_ACTION_LOC(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
SCH_ACTION_ID SCH_EVENT_ACTION SCH_ACTION_ID