| TEMPLATE_ID |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | TEMPLATE_ID |
| ColumnName | TEMPLATE_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEMPLATE_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMPLATE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| TEMPLATE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMPLATE_ID Security Types |
| Name | Current Value |
| TEMPLATE_ID Bound Attachments |
| Name | Current Value |
| TEMPLATE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMPLATE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive TEMPLATE_ID |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE TEMPLATE_ID |
NO |
| TEMPLATE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | CUR_DTE |
| ColumnName | CUR_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CUR_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CUR_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| CUR_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| CUR_DTE Security Types |
| Name | Current Value |
| CUR_DTE Bound Attachments |
| Name | Current Value |
| CUR_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| CUR_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive CUR_DTE |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE CUR_DTE |
NO |
| CUR_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_NM |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | TEMPLATE_NM |
| ColumnName | TEMPLATE_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEMPLATE_NM Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMPLATE_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| TEMPLATE_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMPLATE_NM Security Types |
| Name | Current Value |
| TEMPLATE_NM Bound Attachments |
| Name | Current Value |
| TEMPLATE_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMPLATE_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive TEMPLATE_NM |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE TEMPLATE_NM |
NO |
| TEMPLATE_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | DESCR |
| ColumnName | DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DESCR Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DESCR Security Types |
| Name | Current Value |
| DESCR Bound Attachments |
| Name | Current Value |
| DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DESCR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive DESCR |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE DESCR |
NO |
| DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBJ |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | SUBJ |
| ColumnName | SUBJ |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SUBJ Column Properties |
| Datatype | VARCHAR2(250) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBJ Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 250 |
| Percent Null | 0 |
| SUBJ Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SUBJ Security Types |
| Name | Current Value |
| SUBJ Bound Attachments |
| Name | Current Value |
| SUBJ Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBJ Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive SUBJ |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE SUBJ |
NO |
| SUBJ Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBJ Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBJ Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBJ Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | TEXT |
| ColumnName | TEXT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEXT Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEXT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| TEXT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEXT Security Types |
| Name | Current Value |
| TEXT Bound Attachments |
| Name | Current Value |
| TEXT Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEXT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive TEXT |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE TEXT |
NO |
| TEXT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | NOTES |
| ColumnName | NOTES |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| NOTES Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NOTES Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| NOTES Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NOTES Security Types |
| Name | Current Value |
| NOTES Bound Attachments |
| Name | Current Value |
| NOTES Data Movement Rules |
| Name | Type | Rule Text/Value |
| NOTES Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive NOTES |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE NOTES |
NO |
| NOTES Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | EMAIL_ADDR_FROM |
| ColumnName | EMAIL_ADDR_FROM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EMAIL_ADDR_FROM Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_ADDR_FROM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| EMAIL_ADDR_FROM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EMAIL_ADDR_FROM Security Types |
| Name | Current Value |
| EMAIL_ADDR_FROM Bound Attachments |
| Name | Current Value |
| EMAIL_ADDR_FROM Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL_ADDR_FROM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive EMAIL_ADDR_FROM |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE EMAIL_ADDR_FROM |
NO |
| EMAIL_ADDR_FROM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | EMAIL_TMPL_TYPE_ID |
| ColumnName | EMAIL_TMPL_TYPE_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EMAIL_TMPL_TYPE_ID Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_TMPL_TYPE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| EMAIL_TMPL_TYPE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EMAIL_TMPL_TYPE_ID Security Types |
| Name | Current Value |
| EMAIL_TMPL_TYPE_ID Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_TYPE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL_TMPL_TYPE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive EMAIL_TMPL_TYPE_ID |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE EMAIL_TMPL_TYPE_ID |
NO |
| EMAIL_TMPL_TYPE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | ACT_ID |
| ColumnName | ACT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ACT_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| ACT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ACT_ID Security Types |
| Name | Current Value |
| ACT_ID Bound Attachments |
| Name | Current Value |
| ACT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| ACT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive ACT_ID |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE ACT_ID |
NO |
| ACT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | CRITERIA_CD |
| ColumnName | CRITERIA_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CRITERIA_CD Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CRITERIA_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| CRITERIA_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CRITERIA_CD Security Types |
| Name | Current Value |
| CRITERIA_CD Bound Attachments |
| Name | Current Value |
| CRITERIA_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| CRITERIA_CD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive CRITERIA_CD |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE CRITERIA_CD |
NO |
| CRITERIA_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND |
| Base Object | EMAIL_TEMPLATE_ARCHIVE |
| Attribute Name | SINGLE_SEND_IND |
| ColumnName | SINGLE_SEND_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SINGLE_SEND_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SINGLE_SEND_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SINGLE_SEND_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SINGLE_SEND_IND Security Types |
| Name | Current Value |
| SINGLE_SEND_IND Bound Attachments |
| Name | Current Value |
| SINGLE_SEND_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SINGLE_SEND_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Archive SINGLE_SEND_IND |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE_ARCHIVE SINGLE_SEND_IND |
NO |
| SINGLE_SEND_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |