HWM_TM_REP_WORK_TM_TCAT_V

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
PERSON_ID ASSIGNMENT_ID MEASURE UNIT_OF_MEASURE START_TIME STOP_TIME TM_REC_ID TM_REC_VERSION DAY_GRP_TYPE_ID TCAT_ID STATUS_DATE_FROM STATUS_DATE_TO STATUS_VALUE STATUS_DEF_CD

Query

SQL_Statement

select TIME_RECORDS.PERSON_ID , TIME_RECORDS.ASSIGNMENT_ID , TIME_RECORDS.MEASURE , TIME_RECORDS.UNIT_OF_MEASURE , TIME_RECORDS.START_TIME , TIME_RECORDS.STOP_TIME , TIME_RECORDS.TM_REC_ID , TIME_RECORDS.TM_REC_VERSION , TIME_RECORDS.DAY_GRP_TYPE_ID , TCAT_USG.TCAT_ID , TIME_RECORDS.STATUS_DATE_FROM , TIME_RECORDS.STATUS_DATE_TO , TIME_RECORDS.STATUS_VALUE , STATUS_DEF.STATUS_DEF_CD from HWM_TCAT_USAGES TCAT_USG, HWM_TM_REP_WORK_TM_CORE_V TIME_RECORDS, HWM_TM_STATUS_DEF_B STATUS_DEF where TCAT_USG.TM_BLDG_BLK_ID = TIME_RECORDS.TM_REC_ID AND TCAT_USG.TM_BLDG_BLK_VERSION = TIME_RECORDS.TM_REC_VERSION AND STATUS_DEF.TM_STATUS_DEF_ID = TIME_RECORDS.TM_STATUS_DEF_ID