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. |