Table Detail Report

PRSNL_ORG_RELTN_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel/Organization relationship type
Definition: This table will store a PRSNL's link to ORGANIZATIONs and it will give the ability to specify a type on the relationship. This table is not used for Org security. The PRSNL_ORG_RELTN table is used for that.
Table Type: REFERENCE





Column Detail - PRSNL_ORG_RELTN_TYPE


Column Name Type Null? Definition
ACCESS_POSITION_CD DOUBLE N access position code value
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.
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 N 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 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.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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.
JOB_ROLE_CD DOUBLE N Descibes the personnel's job as related to this organization; e.g., Cardiac Surgeon or Physical Therapist.
ORGANIZATION_ID DOUBLE N The organization that has a relationship with the personnel.
ORG_TYPE_CD DOUBLE N The type of organization that the organization is playing when the personnel to organization relationship type (prsnl_org_reltn_type_cd) is valid.
POSITION_CD DOUBLE N The position the personnel is playing when the personnel to organization relationship type (prsnl_org_reltn_type_cd) is valid.
PRSNL_ID DOUBLE N The personnel that has a relationship with the organization.
PRSNL_ORG_RELTN_TYPE_CD DOUBLE N Identifies the specific type of relationship of the personnel to the organization.
PRSNL_ORG_RELTN_TYPE_ID DOUBLE N This is the value of the unique primary identifier of the prsnl_org_reltn_type table. It is an internal system assigned number.
ROLE_PROFILE VARCHAR(255) Y Identifies the role profile that contains this organization and position.
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 - PRSNL_ORG_RELTN_TYPE


Child Column in PRSNL_ORG_RELTN_TYPE(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in PRSNL_ORG_RELTN_TYPE (PK) Child Table Name Child Column Name
Children: PRSNL_ORG_RELTN_TYPE_ID PRSNL_ROLE_PROFILE_ADDN PRSNL_ORG_RELTN_TYPE_ID


PRSNL_OUT_OF_OFFICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Out Of Office
Definition: This table stores the out of office occurrences for personnel.
Table Type: ACTIVITY





Column Detail - PRSNL_OUT_OF_OFFICE


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.
COMMENTS VARCHAR(250) Y Comments related to this Out Of Office Occurrence
END_DT_TM DATETIME Y The date and time of the Out of Office Occurrence
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_PRSNL_OUT_OF_OFFICE_ID DOUBLE N Used to track versions of the personnel out of office information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PRSNL_ID DOUBLE N Identifier of the Personnel associated with the Out Of Office Occurrence
PRSNL_OUT_OF_OFFICE_ID DOUBLE N Unique generated number that identifies a single row on the PRSNL_OUT_OF_OFFICE table.
REASON_CD DOUBLE N Code Value of the reason for which person went Out Of Office.
START_DT_TM DATETIME Y The start date and time of the Out Of Office Occurrence.
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.



Relationship Detail - PRSNL_OUT_OF_OFFICE


Child Column in PRSNL_OUT_OF_OFFICE(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID




Parent Column in PRSNL_OUT_OF_OFFICE (PK) Child Table Name Child Column Name
Children: PRSNL_OUT_OF_OFFICE_ID PRSNL_OUT_OF_OFFICE_DIST PRSNL_OUT_OF_OFFICE_ID


PRSNL_OUT_OF_OFFICE_DIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Out of Office Distribution
Definition: This table stores how work items are distributed for an Out-of-Office Event.
Table Type: ACTIVITY





Column Detail - PRSNL_OUT_OF_OFFICE_DIST


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.
DISTRIBUTE_TO_PRSNL_ID DOUBLE N Contains the ID of the personnel to which a work item is distributed.
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_OUT_OF_OFFICE_DIST_ID DOUBLE N Used to track versions of the personnel out of office group information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PFT_WORKFLOW_STATUS_CD DOUBLE N The status code representing the related workflow.
PRSNL_OUT_OF_OFFICE_DIST_ID DOUBLE N Unique generated number that identifies a single row on the PRSNL_OUT_OF_OFFICE_DIST table.
PRSNL_OUT_OF_OFFICE_ID DOUBLE N Uniquely identifies the related Out of Office Event.
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.



Relationship Detail - PRSNL_OUT_OF_OFFICE_DIST


Child Column in PRSNL_OUT_OF_OFFICE_DIST(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTE_TO_PRSNL_ID PRSNL PERSON_ID
PRSNL_OUT_OF_OFFICE_ID PRSNL_OUT_OF_OFFICE PRSNL_OUT_OF_OFFICE_ID


PRSNL_PRIV



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel privileges.
Definition: This table is used to store the privileges to maintain the personnel.
Table Type: REFERENCE





Column Detail - PRSNL_PRIV


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.
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 N 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 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.
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.
NAME VARCHAR(50) N The name of the privilege. This needs to be unique for a given personnel_id
PRSNL_ID DOUBLE N The person ID for the person for whom this privilege row is maintained
PRSNL_PRIV_ID DOUBLE N The unique ID of the Personnel Privilege record on the table
SUPER_USER_IND DOUBLE N Indicates whether the user referenced by the personnel_id has super user privileges I.e. can maintain any position, organization etc.
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.
USE_ORG_RELTN_IND DOUBLE N Indicates whether the users org relationship needs to be used for the privilege
USE_POSITION_IND DOUBLE N Indicates whether the users position needs to be used for the privilege



Relationship Detail - PRSNL_PRIV


Child Column in PRSNL_PRIV(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID




Parent Column in PRSNL_PRIV (PK) Child Table Name Child Column Name
Children: PRSNL_PRIV_ID PRSNL_PRIV_COMPONENT PRSNL_PRIV_ID
PRSNL_PRIV_DETAIL PRSNL_PRIV_ID


PRSNL_PRIV_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel privilege component.
Definition: This table is used to store the privilege components for the user to maintain the personnel.
Table Type: REFERENCE





Column Detail - PRSNL_PRIV_COMPONENT


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.
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 N 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 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.
COMPONENT_NAME VARCHAR(50) N The component name for which the privileges are defined in priv_type_nbr
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.
PRIV_TYPE_NBR DOUBLE N The privileges that can be stored for the components1 - view, 2 - modify, (For view and modify it is 3)
PRSNL_PRIV_COMP_ID DOUBLE N The unique ID of the Personnel Privilege Component record
PRSNL_PRIV_ID DOUBLE N The Personnel Privilege row for which the detail is being stored
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 - PRSNL_PRIV_COMPONENT


Child Column in PRSNL_PRIV_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: PRSNL_PRIV_ID PRSNL_PRIV PRSNL_PRIV_ID