CSA_USER_AGREEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSA User Agreement
Definition: This table contains data pertaining to User Agreements in a system. Each agreement is tied to a particular client as well as a role if specified. An example of a user agreement is the agreement you accept when you log into Cerner.
Table Type: REFERENCE





Column Detail - CSA_USER_AGREEMENT


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.
AGREEMENT_TEXT_ID DOUBLE N Foreign key identifier referring back to LONG_TEXT_REFERENCE table where the user agreement text is stored.
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.
INTERVAL_NBR DOUBLE N The value of interval type used to calculate when to display an agreement. Controls how often the user agreement is displayed to the user.
INTERVAL_TYPE_TXT VARCHAR(20) Y The type of interval for the user agreement. An example of this would be Calendar, Logins, etc.
ORGANIZATION_ID DOUBLE N Foreign key to the Organization table. Identifies what organization the user belongs to.
POSITION_CD DOUBLE N Identifies what type of position the agreement is for. Examples are Nurse, RN, Medical Student, 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.
USER_AGREEMENT_ID DOUBLE N Primary key of this table. It is a number sequentially generated by Oracle.



Relationship Detail - CSA_USER_AGREEMENT


Child Column in CSA_USER_AGREEMENT(FK) Parent Table Name Parent Column Name
Parents: AGREEMENT_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in CSA_USER_AGREEMENT (PK) Child Table Name Child Column Name
Children: USER_AGREEMENT_ID CSA_USER_AGREEMENT_ACK USER_AGREEMENT_ID


CSA_USER_AGREEMENT_ACK



Column Section Relationship Section Top of Page


Table-level Detail

Description: CSA User Agreement Acknowledge
Definition: This table contains data indicating a user of Cerner software has acknowledged a User Agreement for the software while logging on.
Table Type: ACTIVITY





Column Detail - CSA_USER_AGREEMENT_ACK


Column Name Type Null? Definition
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.
LOGINS_CNT DOUBLE N The number of times a user has logged in during the time interval for the User Agreement. The length of the interval is kept in the CSA_USER_AGREEMENT table
PERSON_ID DOUBLE N This is a foreign key to table PERSON. Used to identify the user who logged in.
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.
USER_AGREEMENT_ACK_ID DOUBLE N Primary key of this table.
USER_AGREEMENT_ID DOUBLE N Foreign key to the CSA_USER_AGREEMENT table. Identifies the user agreement that was effective during this logon.



Relationship Detail - CSA_USER_AGREEMENT_ACK


Child Column in CSA_USER_AGREEMENT_ACK(FK) Parent Table Name Parent Column Name
Parents: USER_AGREEMENT_ID CSA_USER_AGREEMENT USER_AGREEMENT_ID
PERSON_ID PERSON PERSON_ID