Table Detail Report
PERSON_TRIBAL_AFLTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Tribal Affiliation |
Definition: | Stored information specific to person tribal affiliation details. |
Table Type: | ACTIVITY |
Column Detail - PERSON_TRIBAL_AFLTN
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 | Y | 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 | Y | The person who caused the active_status_cd to be set or change. |
ENROLLED_TRIBAL_MEMBER_IND | DOUBLE | Y | Determine whether patient is enrolled or not for tribal member. |
PERSON_ID | DOUBLE | Y | Person Id that uniquely identifies a single row on the person table. |
PERSON_TRIBAL_AFLTN_ID | DOUBLE | N | Stored information specific to person tribal affiliation details. |
TRIBAL_ENTITY_NOMENCLATURE_ID | DOUBLE | Y | Nomenclature Id that uniquely identifies a single row on the nomenclature table. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - PERSON_TRIBAL_AFLTN
Child Column in PERSON_TRIBAL_AFLTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TRIBAL_ENTITY_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in PERSON_TRIBAL_AFLTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PERSON_TRIBAL_AFLTN_ID | PERSON_TRIBAL_AFLTN_HIST | PERSON_TRIBAL_AFLTN_ID |
PERSON_TRIBAL_AFLTN_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Tribal Affiliation History |
Definition: | Stored historical information specific to person tribal affiliation details. |
Table Type: | ACTIVITY |
Column Detail - PERSON_TRIBAL_AFLTN_HIST
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 | Y | 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 | Y | The person who caused the active_status_cd to be set or change. |
CHANGE_BIT | DOUBLE | Y | Identifies which columns have had a change. |
ENROLLED_TRIBAL_MEMBER_IND | DOUBLE | Y | Determine whether patient is enrolled or not for tribal member. |
PERSON_TRIBAL_AFLTN_HIST_ID | DOUBLE | N | Stored historical information specific to person tribal affiliation details. |
PERSON_TRIBAL_AFLTN_ID | DOUBLE | Y | Person Tribal Affiliation Id that uniquely identifies a single row on the person tribal affiliation table. |
PM_HIST_TRACKING_ID | DOUBLE | Y | This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number. |
TRACKING_BIT | DOUBLE | Y | Identifies which columns are being tracked for history. |
TRIBAL_ENTITY_NOMENCLATURE_ID | DOUBLE | Y | Nomenclature Id that uniquely identifies a single row on the nomenclature table. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - PERSON_TRIBAL_AFLTN_HIST
Child Column in PERSON_TRIBAL_AFLTN_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TRIBAL_ENTITY_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
PERSON_TRIBAL_AFLTN_ID | PERSON_TRIBAL_AFLTN | PERSON_TRIBAL_AFLTN_ID | |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
PERSON_VETERAN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Veteran |
Definition: | Stores information specific to military veterans. |
Table Type: | ACTIVITY |
Column Detail - PERSON_VETERAN
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. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
SERVICE_RLTD_DISABILITY_CD | DOUBLE | N | Defines the status that indicates whether or not the patient has a service related disability. |
SERVICE_RLTD_DISABILITY_PCT | DOUBLE | Y | Determines the percentage of benefits a veteran receives for their service related disability. |
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 - PERSON_VETERAN
Child Column in PERSON_VETERAN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
PERSON_VETERAN_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Veteran History |
Definition: | Used for tracking changes to the person veteran table. |
Table Type: | ACTIVITY |
Column Detail - PERSON_VETERAN_HIST
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. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PERSON_VETERAN_HIST_ID | DOUBLE | N | Unique generated number that identifies a single row on the PERSON_VETERAN_HIST table. |
PM_HIST_TRACKING_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number. |
SERVICE_RLTD_DISABILITY_CD | DOUBLE | N | Defines the status that indicates whether or not the patient has a service related disability. |
SERVICE_RLTD_DISABILITY_PCT | DOUBLE | Y | Determines the percentage of benefits a veteran receives for their service related disability. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
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 - PERSON_VETERAN_HIST
Child Column in PERSON_VETERAN_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
PHONE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Phone |
Definition: | The phone table contains all phone numbers in the system. A row in the phone table is associated with a row in another table (i.e., person, organization, location, etc.). |
Table Type: | ACTIVITY |
Column Detail - PHONE
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. |
BEG_EFFECTIVE_MM_DD | DOUBLE | Y | The numeric representation of the month and day of the month for which this row becomes effective within the current year. |
CALL_INSTRUCTION | VARCHAR(300) | Y | This is a text field to be used to indicate any specific protocol or instructions to be followed when calling this phone number |
CONTACT | VARCHAR(100) | Y | The primary person or contacted for this phone number. |
CONTACT_METHOD_CD | DOUBLE | N | The intended method of contact to be used for phone entry. |
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. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
DESCRIPTION | VARCHAR(100) | Y | This is a text description for identifying who or where this phone number is associated with. |
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. |
END_EFFECTIVE_MM_DD | DOUBLE | Y | The numeric representation of the month and day of the month for which this row is no longer effective within the current year. |
EXTENSION | VARCHAR(100) | Y | This is the local phone extension of a person or place as in a business office environment. |
LONG_TEXT_ID | DOUBLE | Y | Foreign Key to the LONG_TEXT table to provide phone level comments |
MODEM_CAPABILITY_CD | DOUBLE | N | Code value for Modem Capability. (future use) |
OPERATION_HOURS | VARCHAR(255) | Y | free text entry detailing the days and hours this phone number is valid |
PAGING_CODE | VARCHAR(100) | Y | This is the specific pager number to be used after dialing a main or central pager number. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table to which the phone row is related (i.e., person_id, organization_id, etc.) |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The upper case name of the table to which this phone row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.) |
PHONE_FORMAT_CD | DOUBLE | N | Phone Number Format Code Value (future use) |
PHONE_ID | DOUBLE | N | Phone ID is the primary unique identification number of the phone table. It is an internal system assigned sequence number. |
PHONE_NUM | VARCHAR(100) | Y | This is the actual phone number. |
PHONE_NUM_KEY | VARCHAR(100) | Y | Phone_num attribute converted to a string with SPACES and special characters removed. |
PHONE_NUM_KEY_A_NLS | VARCHAR(400) | Y | PHONE_NUM_KEY_A_NLS column |
PHONE_NUM_KEY_NLS | VARCHAR(202) | Y | Stores the corresponding non-English character set values for attribute Phone_Num_Key |
PHONE_TYPE_CD | DOUBLE | N | The phone type is the code set value which identifies the type of phone for the phone row (i.e., home, business, fax, etc.) |
PHONE_TYPE_SEQ | DOUBLE | N | This is the numeric sequence that determines the priority or precedence that one phone row has over another when both phone rows contain the same parent_entity_name, parent_entity_id, and phone_type_cd with the same meaning. |
SOURCE_IDENTIFIER | VARCHAR(255) | Y | Identifier assigned from a master system to this row. Added to support he UK's PDS Allocated Object Identifier. Used to help keep the UK master database in sync with Millennium. |
TEXTING_PERMISSION_CD | DOUBLE | N | Denotes if the owner of the phone has granted permission to be contacted by text message. |
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 - PHONE
Parent Column in PHONE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PHONE_ID | CSM_LST_CONTACT | PHONE_ID |
CSM_REQUESTS | PHONE_ID | ||
CSM_REQUESTS | SELECTED_PHONE_ID | ||
CSM_REQUESTS_ARCHIVE | PHONE_ID | ||
MRU_LOOKUP_FOLLOWUP | PHONE_ID | ||
PFT_AP_REFUND | PHONE_ID | ||
PHONE_HIST | PHONE_ID | ||
PM_TRANSACTION | O_PER_BUS_PHONE_ID | ||
PM_TRANSACTION | O_PER_HOME_PHONE_ID | ||
REFERRAL_CONTACT | PHONE_ID | ||
REQUESTER | BILL_TO_FAX_ID | ||
REQUESTER | BILL_TO_PHONE_ID | ||
REQUESTER | MAIL_TO_FAX_ID | ||
REQUESTER | MAIL_TO_PHONE_ID | ||
ROI_REQUEST | BILL_TO_FAX_ID | ||
ROI_REQUEST | BILL_TO_PHONE_ID | ||
ROI_REQUEST | MAIL_TO_FAX_ID | ||
ROI_REQUEST | MAIL_TO_PHONE_ID |