Table Detail Report
EEM_PROFILE_OUTPUT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM profile output. |
Definition: | EEM profile output. |
Table Type: | REFERENCE |
Column Detail - EEM_PROFILE_OUTPUT
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. |
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. |
ELEMENT_CD | DOUBLE | N | Element type code. |
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. |
ENSURE_FLAG | DOUBLE | N | Ensure flag. |
OUTPUT_ID | DOUBLE | N | Output ID. |
PROFILE_ID | DOUBLE | N | Profile ID. |
SEQUENCE | DOUBLE | N | Sequence. |
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. |
VIEW_FLAG | DOUBLE | N | View flag. |
Relationship Detail - EEM_PROFILE_OUTPUT
Child Column in EEM_PROFILE_OUTPUT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROFILE_ID | EEM_PROFILE | PROFILE_ID |
EEM_PROFILE_POPULATE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM Profile Populate |
Definition: | This table will store the populate build data for profiles. The transaction response element will be related to the registration prompt field to determine where each response element should be populated per profile. |
Table Type: | REFERENCE |
Column Detail - EEM_PROFILE_POPULATE
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
BLANK_OVERRIDE_IND | DOUBLE | N | Identifies if the system will populate with a blank value. |
EEM_PROFILE_POPULATE_ID | DOUBLE | N | This is the unique primary key of this table. It is an internally generated sequence number. |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
FIELD | VARCHAR(255) | N | Identifies the registration prompt field from pm_flx_prompt. This is the field the data will be populated to. |
POPULATE_ELEMENT_CD | DOUBLE | N | Identifies the EEM Populate Element. This is the transaction response element that will be populated. |
PROFILE_ID | DOUBLE | N | This is the unique primary identifier of the eem_profile table. |
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. |
Relationship Detail - EEM_PROFILE_POPULATE
Child Column in EEM_PROFILE_POPULATE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROFILE_ID | EEM_PROFILE | PROFILE_ID |
EEM_PROFILE_PRSNL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM Profile Prsnl |
Definition: | EEM Profile Prsnl |
Table Type: | REFERENCE |
Column Detail - EEM_PROFILE_PRSNL
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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 | Y | 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. |
MOH_LOCAL_USER | VARCHAR(30) | N | Local user identification |
MOH_USER | VARCHAR(30) | N | User identification |
PROFILE_ID | DOUBLE | N | Profile Identifier |
PROFILE_PRSNL_ID | DOUBLE | N | Profile Personnel Identifier |
PRSNL_ID | DOUBLE | N | Personnel Identifier |
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. |
Relationship Detail - EEM_PROFILE_PRSNL
Child Column in EEM_PROFILE_PRSNL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROFILE_ID | EEM_PROFILE | PROFILE_ID |
PRSNL_ID | PRSNL | PERSON_ID |
EEM_PROFILE_REPORT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM PROFILE REPORT |
Definition: | Keeps track of elig reports used by each profile |
Table Type: | REFERENCE |
Column Detail - EEM_PROFILE_REPORT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
DEFAULT_IND | DOUBLE | N | Is this the default report for the profile |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
PROFILE_ID | DOUBLE | N | Key to the profile table |
SCH_REPORT_ID | DOUBLE | N | The unique identifier for the scheduling report. |
SEQ_NBR | DOUBLE | N | Defines the order reports will be displayed in a combo box |
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. |
Relationship Detail - EEM_PROFILE_REPORT
Child Column in EEM_PROFILE_REPORT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROFILE_ID | EEM_PROFILE | PROFILE_ID |
SCH_REPORT_ID | SCH_REPORT | SCH_REPORT_ID |
EEM_PROFILE_SCENARIO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | EEM Profile Scenario |
Definition: | EEM Profile Scenario |
Table Type: | REFERENCE |
Column Detail - EEM_PROFILE_SCENARIO
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. |
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. |
ELEMENT_CD | DOUBLE | N | Element type code. |
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. |
INPUT_ID | DOUBLE | N | Primary key. |
LENGTH | DOUBLE | Y | Length. |
MASK | VARCHAR(100) | Y | Textual input mask. |
PROFILE_ID | DOUBLE | N | Profile ID. |
SCENARIO | DOUBLE | Y | Scenario |
SEARCH_CRITERIA_CD | DOUBLE | N | Search Criteria |
SEQUENCE | DOUBLE | N | Column is not used. Obsolete 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. |
Relationship Detail - EEM_PROFILE_SCENARIO
Child Column in EEM_PROFILE_SCENARIO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROFILE_ID | EEM_PROFILE | PROFILE_ID |