Skip to main content
Skip table of contents

ReadReceipt (ver20.4.0)

Table to contain acknowledgements of documents that have been read.

Column Name

Initial Version

Data Type


Category20.4.0Varchar2(50)Document category(type), such as HEALTHPLAN, GUARDIANALERT, POLICYUPDATE, etc. Required.




Unique identifier from Source Domain, such as HEALTHPLANID or BULLETINITEMS.DCID. Required.

DocumentVersion20.4.0Varchar2(32)Optional document version. Implementation is specific to the category.
LastFirst20.4.0Varchar2(135)Name of the person who read the document. May be the name of the user belonging to UserID, or a manually entered value.
ReadCode20.4.0Number(10,0)Category defined code for the type of acknowledgement. Valid values: 0=Agree, 1=Has questions, 2=Decline, etc. Defaults to 0. Required.
ReadDate20.4.0Timestamp(6)Date and time that the document was read. May be blank while awaiting acknowledgement.
ReadReceiptID20.4.0Number(19,0)Unique sequential number generated by the application. Indexed. Required.
UserID20.4.0Number(19,0)ID of the associated user record of the reader, such as Users.DCID, Students.DCID, Person.DCID, or 0 if UserType = OTHER. Required.
UserType20.4.0Varchar2(10)Type of user that the UserID represents, such as ADMIN, TEACHER, CONTACT, STUDENT, OTHER. Required.
WhenCreated20.4.0Timestamp(6)The date and time the record was created. Defaults to system date. Required.
WhenModified20.4.0Timestamp(6)The date and time the record was modified. Defaults to system date. Required.
WhoCreated20.4.0Varchar2(100)The name of the person who created the record. Defaults to user. Required.
WhoModified20.4.0Varchar2(100)The name of the person who modified the record. Defaults to user. Required.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.