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 |