1. Tables and Views for HCM
  2. PAY_BALANCE_BATCH_HEADERS

PAY_BALANCE_BATCH_HEADERS

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

BATCH_ID

BATCH_NAME

BATCH_STATUS

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

OBJECT_VERSION_NUMBER

BATCH_SOURCE_ID

BATCH_SOURCE

BATCH_SOURCE_CATEGORY

PAY_REQUEST_ID

UPLOAD_DATE

LEGISLATIVE_DATA_GROUP_ID

ENTERPRISE_ID

Query

SQL_Statement

SELECT

PAY_BATCH_HEADERS.BATCH_ID BATCH_ID,

PAY_BATCH_HEADERS.BATCH_NAME BATCH_NAME,

PAY_BATCH_HEADERS.BATCH_STATUS BATCH_STATUS,

PAY_BATCH_HEADERS.CREATED_BY CREATED_BY,

PAY_BATCH_HEADERS.CREATION_DATE CREATION_DATE,

PAY_BATCH_HEADERS.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PAY_BATCH_HEADERS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PAY_BATCH_HEADERS.LAST_UPDATED_BY LAST_UPDATED_BY,

PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PAY_BATCH_HEADERS.BATCH_SOURCE_ID BATCH_SOURCE_ID,

PAY_BATCH_HEADERS.BATCH_SOURCE BATCH_SOURCE,

PAY_BATCH_HEADERS.BATCH_SOURCE_CATEGORY BATCH_SOURCE_CATEGORY,

PAY_BATCH_HEADERS.PAY_REQUEST_ID PAY_REQUEST_ID,

PAY_BATCH_HEADERS.UPLOAD_DATE UPLOAD_DATE,

PAY_BATCH_HEADERS.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

PAY_BATCH_HEADERS.ENTERPRISE_ID ENTERPRISE_ID

FROM

PAY_BATCH_HEADERS