Table Detail Report
PSN_PPR_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | This table relates positions to the relationsihps that are valid for that psn. |
Definition: | This table relates positions to the relationsihps that are valid for that position. Positions are defined on codeset 88, relationships are defined on codesets 331 and 333. |
Table Type: | REFERENCE |
Column Detail - PSN_PPR_RELTN
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 | 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. |
POSITION_CD | DOUBLE | N | Contains the code value for the position. |
PPR_CD | DOUBLE | N | Contains the code value for the relationship. This code value can be for either Encounter Personnel Relation ( code set 333 ) or for Person Personnel Relation code set 331 ). |
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. |
REF_DATAPOINT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Data Point |
Definition: | Defines a point in a reference dataset |
Table Type: | REFERENCE |
Column Detail - REF_DATAPOINT
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 | 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. |
LAST_ACTION_SEQ | DOUBLE | N | This represent the sequence number of the last entry in REF_DATAPOINT_HIST. |
REF_DATAPOINT_ID | DOUBLE | N | This will be the table's primary key. |
REF_DATASET_ID | DOUBLE | N | This is the foreign key to the REF_DATASET table. Each data point belongs to exactly one dataset. |
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. |
X_VAL | DOUBLE | N | This is the X value of the datapoint. The unit of measure will be the unit code of the first section of the X axis in the CHART_DEFINITION table. |
Y_VAL | DOUBLE | N | This is the Y value of the datapoint. The unit of measure will be the unit code of the y axis in the CHART_DEFINITION table. |
Relationship Detail - REF_DATAPOINT
Child Column in REF_DATAPOINT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REF_DATASET_ID | REF_DATASET | REF_DATASET_ID |
Parent Column in REF_DATAPOINT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REF_DATAPOINT_ID | REF_DATAPOINT_HIST | REF_DATAPOINT_ID |
REF_DATAPOINT_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Data point History |
Definition: | Defines a historical record of a point in a reference dataset |
Table Type: | REFERENCE |
Column Detail - REF_DATAPOINT_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | N | Action Date Time |
ACTION_SEQ | DOUBLE | N | This represents the sequence number of this entry. |
ACTION_TYPE_FLAG | DOUBLE | N | Action Type Flag |
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 | 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. |
REF_DATAPOINT_ID | DOUBLE | N | This will be the table's primary key. |
REF_DATASET_ID | DOUBLE | N | This is the foreign key to the REF_DATASET table. Each data point belongs to exactly one dataset. |
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. |
X_VAL | DOUBLE | N | This is the X value of the datapoint. The unit of measure will be the unit code of the first section of the X axis in the CHART_DEFINITION table. |
Y_VAL | DOUBLE | N | This is the Y value of the datapoint. The unit of measure will be the unit code of the y axis in the CHART_DEFINITION table. |
Relationship Detail - REF_DATAPOINT_HIST
Child Column in REF_DATAPOINT_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REF_DATAPOINT_ID | REF_DATAPOINT | REF_DATAPOINT_ID |
REF_DATASET_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Dataset History |
Definition: | Defines a historical record of a dataset of reference data in a growth chart |
Table Type: | REFERENCE |
Column Detail - REF_DATASET_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | N | Action Date Time |
ACTION_SEQ | DOUBLE | N | This represents the sequence number of this entry. Part of Primary Key |
ACTION_TYPE_FLAG | DOUBLE | N | Action Type Flag |
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. |
CHART_DEFINITION_ID | DOUBLE | N | This is the foreign key to the CHART_DEFINITION table. Each dataset belongs to exactly one chart definition. |
DISPLAY_NAME | VARCHAR(60) | N | This is the display name of the dataset. |
DISPLAY_TYPE_CD | DOUBLE | N | This indicates the type of line to be displayed for this dataset. |
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. |
REF_DATASET_ID | DOUBLE | N | This will be the table's primary key. Foreign Key from REF_DATASET |
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 - REF_DATASET_HIST
Child Column in REF_DATASET_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REF_DATASET_ID | REF_DATASET | REF_DATASET_ID |
REF_DATASTATS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Data Statistics |
Definition: | Defines statistical measures for a particular range on a growth chart. |
Table Type: | REFERENCE |
Column Detail - REF_DATASTATS
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. |
BOX_COX_POWER_VALUE | DOUBLE | Y | This is the 'power in the Box-Cox transformation' for the population as given by the source of the chart information. (This is the L in the CDC's LMS parameters.) |
CHART_DEFINITION_ID | DOUBLE | N | This is the foreign key to the CHART_DEFINITION table. Each data point belongs to exactly one dataset. |
COEFFNT_VAR_VALUE | DOUBLE | Y | This is the generalized coefficient of variation value for the population as given by the source of the chart information. (This is the S in the CDC's LMS parameters.) |
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. |
LAST_ACTION_SEQ | DOUBLE | N | This represent the sequence number of the last entry in REF_DATASTATS_HIST. |
MEAN_VALUE | DOUBLE | Y | This is the mean value for the population as given by the source of the chart information. |
MEDIAN_VALUE | DOUBLE | Y | This is the median value for the population as given by the source of the chart information. (This is the M in the CDC's LMS parameters.) |
REF_DATASTATS_ID | DOUBLE | N | This will be the table's primary key. |
STD_DEV_VALUE | DOUBLE | Y | This is the standard deviation for the population as given by the source of the chart information. |
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. |
X_MAX_VAL | DOUBLE | N | This is the maximum val on the X axis for which the stats apply. Units are in the unit_cd of the X axis on the CHART_DEFINITION table. |
X_MIN_VAL | DOUBLE | N | This is the minimum val on the X axis for which the stats apply. Units are in the unit_cd of the X axis on the CHART_DEFINITION table. |
Relationship Detail - REF_DATASTATS
Child Column in REF_DATASTATS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHART_DEFINITION_ID | CHART_DEFINITION | CHART_DEFINITION_ID |
Parent Column in REF_DATASTATS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REF_DATASTATS_ID | REF_DATASTATS_HIST | REF_DATASTATS_ID |