Table Detail Report

RES_SIGN_ACT_SUBTYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Resident Sign Activity Sub Type
Definition: The res_sign_act_subtype contains the resident type indicator
Table Type: REFERENCE





Column Detail - RES_SIGN_ACT_SUBTYPE


Column Name Type Null? Definition
ACT_SUBTYPE_CD DOUBLE N This is a foreign key to the code_value table. It uniquely identifies the activity sub type code.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - RES_SIGN_ACT_SUBTYPE


Child Column in RES_SIGN_ACT_SUBTYPE(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID
PERSON_ID RAD_RES_INFO PERSON_ID


TRACK_PT_LIBRARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Point Library
Definition: The Track_Pt_Library table is a child of the service resource table and contains information specific to a tracking point or library.
Table Type: REFERENCE





Column Detail - TRACK_PT_LIBRARY


Column Name Type Null? Definition
FILING_METHOD_CD DOUBLE N The Filing_Method_Cd identifies the filing method used within the specified library.
FILING_NUMBER_LENGTH DOUBLE Y Number of characters specified as the terminal filing number
LIB_IND DOUBLE N The Lib_Ind indicates if this row is a library or a tracking point.
PULL_LIST_BY_SECT_IND DOUBLE Y The Pull_List_By_Sect_Ind indicates if pull lists generated within this library should be sorted by section.
PURGE_LIB_IND DOUBLE Y The Purge_Lib_Ind indicates if this library was set up as a purge library.
SERVICE_RESOURCE_CD DOUBLE N The Service_Resource_Cd is a foreign key to the Service_Resource table. It uniquely identifies the library/tracking point.
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 - TRACK_PT_LIBRARY


Child Column in TRACK_PT_LIBRARY(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in TRACK_PT_LIBRARY (PK) Child Table Name Child Column Name
Children: SERVICE_RESOURCE_CD FILING_NUMBER_POSITION SERVICE_RESOURCE_CD
PULL_TRANS_REQ FROM_LIB_CD
PULL_TRANS_REQ TO_LIB_CD