CMP_TCS_PER_PERD_STMT_SEC_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

PER_PERD_STMT_ID LOCAL_CURRENCY_CODE PER_PERD_ID STMT_ID STMT_PERD_ID PERD_RUN_ID PERSON_ID LEGAL_ENTITY_ID ASSIGNMENT_ID JOB_ID WORKER_NUMBER HIRE_DATE XML_LOB_STMT BUSINESS_GROUP_ID HIDE_SUMMARY_FLAG DSP_DETAIL_JOB_FLAG REQUEST_ID PROCESS_REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN POSITION_ID SALARY_AMOUNT SALARY_CURRENCY SALARY_PERIOD_CODE END_DATE STMT_VIEWED_DATE

Query

SQL_Statement

SELECT PER_PERD_STMT_ID, LOCAL_CURRENCY_CODE, PER_PERD_ID, STMT_ID, STMT_PERD_ID, PERD_RUN_ID, PERSON_ID, LEGAL_ENTITY_ID, ASSIGNMENT_ID, JOB_ID, WORKER_NUMBER, HIRE_DATE, XML_LOB_STMT, BUSINESS_GROUP_ID, HIDE_SUMMARY_FLAG, DSP_DETAIL_JOB_FLAG, REQUEST_ID, PROCESS_REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, POSITION_ID, SALARY_AMOUNT, SALARY_CURRENCY, SALARY_PERIOD_CODE, END_DATE, STMT_VIEWED_DATE FROM CMP_TCS_PER_PERD_STMT