Table Detail Report

RRD_PHONE_MASK



Column Section Top of Page


Table-level Detail

Description: RRD PHONE MASK
Definition: Table containing phone masks which define how a phone number is displayed
Table Type: REFERENCE





Column Detail - RRD_PHONE_MASK


Column Name Type Null? Definition
AREA_CODE VARCHAR(25) Y Area Code portion of phone maskColumn
COUNTRY_CODE VARCHAR(25) Y Country code portion of phone maskColumn
DESCRIPTION VARCHAR(50) N Name of phone maskColumn
EXCHANGE VARCHAR(25) Y Exchange portion of phone maskColumn
PHONE_MASK_ID DOUBLE N Unique ID for a phone maskColumn
SUFFIX VARCHAR(50) Y Suffix portion of phone maskColumn
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.


RRD_SECURE_EMAIL_ATTACH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Remote Report Distribution Secure Email Attachments ;
Definition: Stores the attachment information pertaining to every secure email sent by RRD.
Table Type: ACTIVITY





Column Detail - RRD_SECURE_EMAIL_ATTACH


Column Name Type Null? Definition
MEDIA_OBJECT_IDENTIFIER VARCHAR(64) Y The unique identifier for the document in CAMM.
MEDIA_OBJECT_NAME VARCHAR(255) Y The name of the document in CAMM.;
MEDIA_OBJECT_VERSION_NBR DOUBLE Y The version of the document in CAMM.;
RRD_SECURE_EMAIL_ATTACH_ID DOUBLE N PRIMARY KEY
RRD_SECURE_EMAIL_DETAIL_ID DOUBLE Y Foreign key to RRD_SECURE_EMAIL_DETAIL table, indicating the secure email this recipient was including with.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - RRD_SECURE_EMAIL_ATTACH


Child Column in RRD_SECURE_EMAIL_ATTACH(FK) Parent Table Name Parent Column Name
Parents: RRD_SECURE_EMAIL_DETAIL_ID RRD_SECURE_EMAIL_DETAIL RRD_SECURE_EMAIL_DETAIL_ID


RRD_SECURE_EMAIL_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Remote Report Distribution Secure Email Details
Definition: Stores the primary information representing every secure email sent by RRD.
Table Type: ACTIVITY





Column Detail - RRD_SECURE_EMAIL_DETAIL


Column Name Type Null? Definition
EMAIL_MESSAGE_CLOB LONGTEXT Y defines the message body for the email.
EMAIL_SUBJECT_TXT VARCHAR(255) Y defines the subject for the email.;
MESSAGE_IDENT VARCHAR(255) Y A globally unique identifier defined when the email is sent. This represents the message-id field as defined by the --Internet Message Format-- standard
RRD_SECURE_EMAIL_DETAIL_ID DOUBLE N PRIMARY KEY
SENDER_EMAIL_ADDRESS_TXT VARCHAR(100) Y The reference to the LONG_TEXT row that defines the email address that this email was sent from
SENDER_ID DOUBLE Y Foreign key to PRSNL table, indicates the PRNSL ID who sent the email.
SENT_DT_TM DATETIME Y Date and time when the original email request was sent.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - RRD_SECURE_EMAIL_DETAIL


Child Column in RRD_SECURE_EMAIL_DETAIL(FK) Parent Table Name Parent Column Name
Parents: SENDER_ID PRSNL PERSON_ID




Parent Column in RRD_SECURE_EMAIL_DETAIL (PK) Child Table Name Child Column Name
Children: RRD_SECURE_EMAIL_DETAIL_ID RRD_SECURE_EMAIL_ATTACH RRD_SECURE_EMAIL_DETAIL_ID
RRD_SECURE_EMAIL_RECIP RRD_SECURE_EMAIL_DETAIL_ID


RRD_SECURE_EMAIL_RECIP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Remote Report Distribution Secure Email Recipients
Definition: Stores the recipient information pertaining to every secure email sent by RRD.
Table Type: ACTIVITY





Column Detail - RRD_SECURE_EMAIL_RECIP


Column Name Type Null? Definition
RECIPIENT_EMAIL_ADDRESS_TXT VARCHAR(100) Y defines the email address that this email was sent to.;
RECIPIENT_TYPE_FLAG DOUBLE Y Indicates the type of email delivery (e.g. TO, CC, BCC).;
RRD_SECURE_EMAIL_DETAIL_ID DOUBLE Y Foreign key to RRD_SECURE_EMAIL_DETAIL table, indicating the secure email this recipient was including with.
RRD_SECURE_EMAIL_RECIP_ID DOUBLE N PRIMARY KEY
STATUS_CD DOUBLE Y Status of the email for this recipient.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - RRD_SECURE_EMAIL_RECIP


Child Column in RRD_SECURE_EMAIL_RECIP(FK) Parent Table Name Parent Column Name
Parents: RRD_SECURE_EMAIL_DETAIL_ID RRD_SECURE_EMAIL_DETAIL RRD_SECURE_EMAIL_DETAIL_ID


SESSION_LOG



Column Section Top of Page


Table-level Detail

Description: Session Log
Definition: The Session_Log table provides detailed information about the session transmission.
Table Type: ACTIVITY





Column Detail - SESSION_LOG


Column Name Type Null? Definition
MESSAGE_CD DOUBLE N A series of unique message codes that represents different transmission status data. I.e. Message Code 0 = Normal Transmission.
MESSAGE_TEXT VARCHAR(200) Y Text that defines the session messages.Column
QUALIFIER DOUBLE N This is needed in case the same session is being retransmitted.
SESSION_NUM DOUBLE N Sequential number assigned at time of transmission.
SESS_DT_TM DATETIME Y The date and time that a specific session was created. This date and time is the time the report or group of reports is selected for transmission by the communications port.
SESS_LEVEL DOUBLE Y Determines at what log level this message will display.Column
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.