Table Detail Report
FAMILY_RELATION_EXCEPTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Family relationship exception |
Definition: | Removed suggested family relationships |
Table Type: | ACTIVITY |
Column Detail - FAMILY_RELATION_EXCEPTION
Column Name | Type | Null? | Definition |
---|---|---|---|
FAMILY_RELATION_EXCEPTION_ID | DOUBLE | N | Identifies the relationship exception for a Person |
PERSON_ID | DOUBLE | N | Person for whom the relationship exception exists |
SUGGESTED_RELATED_PERSON_ID | DOUBLE | N | The related person to Related Person for whom a relation suggestion is an exception. |
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 - FAMILY_RELATION_EXCEPTION
Child Column in FAMILY_RELATION_EXCEPTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
SUGGESTED_RELATED_PERSON_ID | PERSON | PERSON_ID |
GUAR_FINANCIAL_RESP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Guarantor Financial Responsibility |
Definition: | The Guarnator Financial Responsibility table defines financial responsibility of the guarantor. |
Table Type: | ACTIVITY |
Column Detail - GUAR_FINANCIAL_RESP
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. |
FIN_RESP_QUAL_CD | DOUBLE | N | The financial qualifier code defines the type of value (i.e. monetary amount or percentage) for which the guarantor is responsible. |
FIN_RESP_VALUE | DOUBLE | N | The financial responsibility value as defined by the qualifier code for which the guarantor is responsible. |
GUAR_FINANCIAL_RESP_ID | DOUBLE | N | Unique generated number that identifies a single row on the GUAR_FINANCIAL_RESP table. |
GUAR_FINANCIAL_RESP_TYPE_CD | DOUBLE | N | Defines the scope of the guarantor¿s financial responsibility. |
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 - GUAR_FINANCIAL_RESP
Parent Column in GUAR_FINANCIAL_RESP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | GUAR_FINANCIAL_RESP_ID | GUAR_FINANCIAL_RESP_HIST | GUAR_FINANCIAL_RESP_ID |
GUAR_FIN_RESP_RELTN | GUAR_FINANCIAL_RESP_ID | ||
GUAR_FIN_RESP_RELTN_HIST | GUAR_FINANCIAL_RESP_ID |
GUAR_FINANCIAL_RESP_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Guarantor Financial Responsibility History |
Definition: | Used for tracking history of changes to guarantor financial responsibility. |
Table Type: | ACTIVITY |
Column Detail - GUAR_FINANCIAL_RESP_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. |
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. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
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. |
FIN_RESP_QUAL_CD | DOUBLE | N | The financial qualifier code defines the type of value (i.e. monetary amount or percentage) for which the guarantor is responsible. |
FIN_RESP_VALUE | DOUBLE | N | The financial responsibility value as defined by the qualifier code for which the guarantor is responsible. |
GUAR_FINANCIAL_RESP_HIST_ID | DOUBLE | N | Unique generated number that identifies a single row on the GUAR_FINANCIAL_RESP_HIST table. |
GUAR_FINANCIAL_RESP_ID | DOUBLE | N | Unique generated number that identifies a single row on the GUAR_FINANCIAL_RESP table. |
GUAR_FINANCIAL_RESP_TYPE_CD | DOUBLE | N | Defines the scope of the guarantor¿s financial responsibility. |
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. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
TRANSACTION_DT_TM | DATETIME | N | ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time. |
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 - GUAR_FINANCIAL_RESP_HIST
Child Column in GUAR_FINANCIAL_RESP_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GUAR_FINANCIAL_RESP_ID | GUAR_FINANCIAL_RESP | GUAR_FINANCIAL_RESP_ID |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |
GUAR_FIN_RESP_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Guarantor |
Definition: | Relates the financial responsibility to the guarantor. |
Table Type: | ACTIVITY |
Column Detail - GUAR_FIN_RESP_RELTN
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 | **OBSOLETE**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 | **OBSOLETE**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. |
GUAR_FINANCIAL_RESP_ID | DOUBLE | N | Unique generated number identifying the row on the GUAR_FINANCIAL_RESP table to which the guarantor is related. |
GUAR_FINANCIAL_RESP_TYPE_CD | DOUBLE | N | **OBSOLETE **Defines the scope of the guarantor¿s financial responsibility. |
GUAR_FIN_RESP_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the GUAR_FIN_RESP_RELTN table. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table representing the guarantor and to which the financial responsibility row is related. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The upper case name of the table to which this financial responsibility row is related (i.e., person_person_reltn, encntr_person_reltn, person_org_reltn, encntr_org_reltn, 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. |
Relationship Detail - GUAR_FIN_RESP_RELTN
Child Column in GUAR_FIN_RESP_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GUAR_FINANCIAL_RESP_ID | GUAR_FINANCIAL_RESP | GUAR_FINANCIAL_RESP_ID |
Parent Column in GUAR_FIN_RESP_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | GUAR_FIN_RESP_RELTN_ID | GUAR_FIN_RESP_RELTN_HIST | GUAR_FIN_RESP_RELTN_ID |
GUAR_FIN_RESP_RELTN_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Guarantor Financial Responsibility Relationship History |
Definition: | Used for tracking history of changes to the guarantor financial responsibility relationship. |
Table Type: | ACTIVITY |
Column Detail - GUAR_FIN_RESP_RELTN_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. |
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. |
CHANGE_BIT | DOUBLE | N | Identifies which columns have had a change. |
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. |
GUAR_FINANCIAL_RESP_ID | DOUBLE | N | Unique generated number that identifies a single row on the GUAR_FINANCIAL_RESP table. |
GUAR_FINANCIAL_RESP_TYPE_CD | DOUBLE | N | **OBSOLETE** This functionality for this column has been moved to the GUAR_FINANCIAL_RESP table. Defines the scope of the guarantor¿s financial responsibility. |
GUAR_FIN_RESP_RELTN_HIST_ID | DOUBLE | N | Unique generated number identifying the row on the GUAR_FINANCIAL_RESP table to which the guarantor is related. |
GUAR_FIN_RESP_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the GUAR_FIN_RESP_RELTN table. |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary identifier of the table representing the guarantor and to which the financial responsibility row is related. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The upper case name of the table to which this financial responsibility row is related (i.e., person_person_reltn, encntr_person_reltn, person_org_reltn, encntr_org_reltn, etc.). |
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. |
TRACKING_BIT | DOUBLE | N | Identifies which columns are being tracked for history. |
TRANSACTION_DT_TM | DATETIME | N | ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time. |
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 - GUAR_FIN_RESP_RELTN_HIST
Child Column in GUAR_FIN_RESP_RELTN_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GUAR_FINANCIAL_RESP_ID | GUAR_FINANCIAL_RESP | GUAR_FINANCIAL_RESP_ID |
GUAR_FIN_RESP_RELTN_ID | GUAR_FIN_RESP_RELTN | GUAR_FIN_RESP_RELTN_ID | |
PM_HIST_TRACKING_ID | PM_HIST_TRACKING | PM_HIST_TRACKING_ID |