Table Detail Report

PFT_UMDAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Universal Method for Determining Ability to Pay
Definition: This table stores data related to UMDAP for California Mental Hospitals.
Table Type: ACTIVITY





Column Detail - PFT_UMDAP


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 Y 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.
CREATE_DT_TM DATETIME N Contains the UMDAP creation date.
CREATE_PRSNL_ID DOUBLE N Contains the id of the person who created the UMDAP
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.
INTERIM_IND DOUBLE Y Identifies UMDAPs within the system as either annual or interim for data report reasons.
NUM_OF_DEPENDENTS DOUBLE N Number of Dependants related to the Guarantor.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PFT_UMDAP_ID DOUBLE N Primary Key
PREVIOUS_YEAR_REMAINING DOUBLE N UMDAP Remaining amount from previous year.
SIGNATURE_FILED_IND DOUBLE Y Signature filed :0 - No, 1 - Yes
TOTAL_AMT DOUBLE N Total Amount totaled from questions.
UMDAP_AMT_REMAINING DOUBLE N Remaining amount for the year.
UMDAP_YEARLY_TOTAL DOUBLE N Total amount expected to by the guarantor.
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 - PFT_UMDAP


Child Column in PFT_UMDAP(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in PFT_UMDAP (PK) Child Table Name Child Column Name
Children: PFT_UMDAP_ID PFT_UMDAP_HIST PFT_UMDAP_ID
PFT_UMDAP_QUESTION PFT_UMDAP_ID


PFT_UMDAP_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT UMDAP HIST
Definition: This table stores Updated information concerning UMDAP Remaining amounts
Table Type: ACTIVITY





Column Detail - PFT_UMDAP_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.
AMT_MOD_DT_TM DATETIME Y Date of the Modification.
CURR_AMT DOUBLE N Current Amount of Remaining Balance at the time of the transaction.
HIST_REASON_TYPE_CD DOUBLE N This codeset provies a list of reasons that may cause an update on the UMDAP remaining amount.
PFT_CHARGE_ID DOUBLE N Foreign Key to the PFT_CHARGE table.
PFT_UMDAP_HIST_ID DOUBLE N Primary Key
PFT_UMDAP_ID DOUBLE N Foreign Key to the pft_umdap table.
PREV_AMT DOUBLE N Previous Amount of Remaining Balance.
PRSNL_ID DOUBLE N Personnel responsible for the amount modification.
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 - PFT_UMDAP_HIST


Child Column in PFT_UMDAP_HIST(FK) Parent Table Name Parent Column Name
Parents: PFT_UMDAP_ID PFT_UMDAP PFT_UMDAP_ID
PRSNL_ID PRSNL PERSON_ID


PFT_UMDAP_QUESTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT UMDAP QUESTION
Definition: This table stores the answers to UMDAP related questions.
Table Type: ACTIVITY





Column Detail - PFT_UMDAP_QUESTION


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.
ANSWER_AMT DOUBLE N Dollar amount returned by the user.
PFT_UMDAP_ID DOUBLE N Foreign Key to PFT_UMDAP
PFT_UMDAP_QUESTION_ID DOUBLE N Primary Key
PFT_UMDAP_QUES_CD DOUBLE N This code value relates to the specific umdap question answered by the user. Not every question needs to be answered for a set.
PFT_UMDAP_QUES_GRP_CD DOUBLE N This code value relates to the grouping mechanism for the UMDAP questions code set.
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 - PFT_UMDAP_QUESTION


Child Column in PFT_UMDAP_QUESTION(FK) Parent Table Name Parent Column Name
Parents: PFT_UMDAP_ID PFT_UMDAP PFT_UMDAP_ID


PFT_VIEW



Column Section Top of Page


Table-level Detail

Description: ProFit View
Definition: Relationship between custom views and default views
Table Type: REFERENCE





Column Detail - PFT_VIEW


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.
ENTITY_TYPE_CD DOUBLE N The entity for which the view is associated i.e. ACCOUNT, PFTENCNTR, HOLD
PFT_VIEW_ID DOUBLE N Identifies the relationships between custom views and default views
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.
VIEW_CREATE_DT_TM DATETIME N DateTime of view creation
VIEW_DESC_TXT VARCHAR(200) Y Description of a view as given by the view author.
VIEW_NAME_TXT VARCHAR(100) Y Name of a view as given by the view author
VIEW_NAME_TXT_KEY VARCHAR(100) Y Name of a view as given by the view author (Uppercase, less spaces and special characters)
VIEW_NAME_TXT_KEY_A_NLS VARCHAR(400) Y VIEW_NAME_TXT_KEY_A_NLS column
VIEW_NAME_TXT_KEY_NLS VARCHAR(202) Y Name of a view as given by the view author (National Language Support)
VIEW_SOURCE_TYPE_FLAG DOUBLE N Source type for view
VIEW_TYPE_CD DOUBLE N Type of view, i.e. LISTview, DETAILview, TASKview


RC_ACTION_CODE_AUTH_RELTN



Column Section Top of Page


Table-level Detail

Description: Revenue Cycle Action Code Authorization Relation
Definition: Stores authorization relationship between action code and entity.
Table Type: REFERENCE





Column Detail - RC_ACTION_CODE_AUTH_RELTN


Column Name Type Null? Definition
ACTION_CD DOUBLE N The client defined action code.
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.
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.
PARENT_ENTITY_ID DOUBLE N id number of the selected criteria located on table .
PARENT_ENTITY_NAME VARCHAR(30) N Identifies the name of the related entity.
RC_ACTION_CODE_AUTH_RELTN_ID DOUBLE N Uniquely identifies a relationship between the action code and the entity
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.