Table Detail Report

BR_PRSNL_ELIG_PROV_GRP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Personnel Eligible Provider Group Relation
Definition: Stores a group of personnel that are associated to a particular Eligible Provider Group.
Table Type: REFERENCE





Column Detail - BR_PRSNL_ELIG_PROV_GRP_R


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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
BR_GROUP_ID DOUBLE N The group that is related to this personnel.
BR_PRSNL_ELIG_PROV_GRP_R_ID DOUBLE N Unique, generated number that identifies a single row on the BR_PRSNL_ELIG_PROV_GRP_R table.
END_EFFECTIVE_DT_TM DATETIME N 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.
PRSNL_GROUP_RELTN_ID DOUBLE N The Personnel Group that this personnel fis related to.
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 - BR_PRSNL_ELIG_PROV_GRP_R


Child Column in BR_PRSNL_ELIG_PROV_GRP_R(FK) Parent Table Name Parent Column Name
Parents: BR_GROUP_ID BR_GROUP BR_GROUP_ID
PRSNL_GROUP_RELTN_ID PRSNL_GROUP_RELTN PRSNL_GROUP_RELTN_ID


BR_PRSNL_ITEM_RELTN



Column Section Top of Page


Table-level Detail

Description: BEDROCK PERSONNEL ITEM RELATIONSHIP
Definition: solutions & steps for each user
Table Type: REFERENCE





Column Detail - BR_PRSNL_ITEM_RELTN


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_PRSNL_ID DOUBLE N identifier of the user from br_prsnl table
BR_PRSNL_ITEM_RELTN_ID DOUBLE N BEDROCK PRSNL ITEM RELATION IDENTIFIER value
ITEM_DISPLAY VARCHAR(255) N display value of ""STEP"" or ""SOLUTION""
ITEM_LEAD_IND DOUBLE N set to 1 if user is considered a ""leader"" (team lead, owner, etc.) for the item
ITEM_MEAN VARCHAR(255) N meaning of ""STEP"" or ""SOLUTION""
ITEM_TYPE VARCHAR(255) N item type value
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.


BR_PRSNL_SPECIALTY



Column Section Top of Page


Table-level Detail

Description: BEDROCK PERSONNEL SPECIALTY
Definition: speciality associated with the personnel
Table Type: REFERENCE





Column Detail - BR_PRSNL_SPECIALTY


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
PRSNL_ID DOUBLE N Unique identifier for the table
SPECIALTY_ID DOUBLE N The specialty associated to the personnel
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.


BR_PRSNL_SUBMIT



Column Section Top of Page


Table-level Detail

Description: BEDROCK PERSONNEL SUBMIT
Definition: who submitted the personnel data
Table Type: REFERENCE





Column Detail - BR_PRSNL_SUBMIT


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
PRSNL_ID DOUBLE N Unique identifier for the table
SUBMIT_BY VARCHAR(100) Y Who the personnel was submitted by.
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.


BR_PRTL_URL_SE_R_CD_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Portal URL Service Entity Relationship Code Relation
Definition: Stores the relationship between portal url relations and codes. Portal urls which are related to CCNs or Eligible Providers need to have event codes tied to those .relationships, in order to pull data if certain events occur.
Table Type: REFERENCE





Column Detail - BR_PRTL_URL_SE_R_CD_R


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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
BR_PORTAL_URL_SVC_ENTITY_R_ID DOUBLE N The primary key from the br_portal_url_svc_entity_r table. Indicates the portal relationship to which these codes are being tied.
BR_PRTL_URL_SE_R_CD_R_ID DOUBLE N Unique generated number that identifies a single row on the BR_PRTL_URL_SE_R_CD_R table.
CODE_TYPE_FLAG DOUBLE N The type of the code value being tied to the relationship. Can be different for codes from the same code_set.
END_EFFECTIVE_DT_TM DATETIME N 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.
ORIG_PRTL_URL_SE_R_CD_R_ID DOUBLE N Used for versioning. Contains the value of the PK for a particular set of rows in BR_PRTL_URL_SE_R_CD_R.
PORTAL_ATTR_CD_VALUE DOUBLE N The code value being tied to the portal relationship.
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 - BR_PRTL_URL_SE_R_CD_R


Child Column in BR_PRTL_URL_SE_R_CD_R(FK) Parent Table Name Parent Column Name
Parents: BR_PORTAL_URL_SVC_ENTITY_R_ID BR_PORTAL_URL_SVC_ENTITY_R BR_PORTAL_URL_SVC_ENTITY_R_ID
ORIG_PRTL_URL_SE_R_CD_R_ID BR_PRTL_URL_SE_R_CD_R BR_PRTL_URL_SE_R_CD_R_ID




Parent Column in BR_PRTL_URL_SE_R_CD_R (PK) Child Table Name Child Column Name
Children: BR_PRTL_URL_SE_R_CD_R_ID BR_PRTL_URL_SE_R_CD_R ORIG_PRTL_URL_SE_R_CD_R_ID