[Home] [Help] [Dependency Information]
Object Name: | GHR_MASS_SALARIES# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MASS_SALARY_ID | NUMBER | Yes | ||
NAME | VARCHAR2 | (30) | Yes | |
PA_REQUEST_ID | NUMBER | (15) | ||
EFFECTIVE_DATE | DATE | Yes | ||
EXECUTIVE_ORDER_NUMBER | VARCHAR2 | (15) | ||
EXECUTIVE_ORDER_DATE | DATE | |||
USER_TABLE_ID | NUMBER | (9) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
DUTY_STATION_ID | NUMBER | (15) | ||
PERSONNEL_OFFICE_ID | VARCHAR2 | (4) | ||
AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | ||
SUBMIT_FLAG | VARCHAR2 | (1) | ||
OPM_ISSUANCE_NUMBER | VARCHAR2 | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OPM_ISSUANCE_DATE | DATE | |||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
PROCESS_TYPE | VARCHAR2 | (1) | ||
LOCALITY_PAY_AREA_CODE | VARCHAR2 | (2) | ||
NOA_CODE | VARCHAR2 | (4) | ||
NTE_DATE | DATE | |||
TARGET_BARGAINING_UNIT_STATUS | VARCHAR2 | (30) | ||
TARGET_FLSA_CATEGORY | VARCHAR2 | (30) | ||
TARGET_OCC_CODE | VARCHAR2 | (150) | ||
TARGET_AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | ||
TARGET_DUTY_STATION_ID | NUMBER | (15) | ||
TARGET_DUTY_STATION_CODE | VARCHAR2 | (9) | ||
TARGET_JOB_ID | NUMBER | (15) | ||
TARGET_FUNCTIONAL_CLASS | VARCHAR2 | (30) | ||
BARGAINING_UNIT_STATUS | VARCHAR2 | (30) | ||
JOB_ID | NUMBER | (15) | ||
FLSA_CATEGORY | VARCHAR2 | (30) | ||
TARGET_MASS_ACTION_ID | NUMBER | |||
TARGET_MASS_ACTION_TYPE | VARCHAR2 | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_SALARY_ID
, NAME
, PA_REQUEST_ID
, EFFECTIVE_DATE
, EXECUTIVE_ORDER_NUMBER
, EXECUTIVE_ORDER_DATE
, USER_TABLE_ID
, ORGANIZATION_ID
, DUTY_STATION_ID
, PERSONNEL_OFFICE_ID
, AGENCY_CODE_SUBELEMENT
, SUBMIT_FLAG
, OPM_ISSUANCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OPM_ISSUANCE_DATE
, BUSINESS_GROUP_ID
, PROCESS_TYPE
, LOCALITY_PAY_AREA_CODE
, NOA_CODE
, NTE_DATE
, TARGET_BARGAINING_UNIT_STATUS
, TARGET_FLSA_CATEGORY
, TARGET_OCC_CODE
, TARGET_AGENCY_CODE_SUBELEMENT
, TARGET_DUTY_STATION_ID
, TARGET_DUTY_STATION_CODE
, TARGET_JOB_ID
, TARGET_FUNCTIONAL_CLASS
, BARGAINING_UNIT_STATUS
, JOB_ID
, FLSA_CATEGORY
, TARGET_MASS_ACTION_ID
, TARGET_MASS_ACTION_TYPE
FROM HR.GHR_MASS_SALARIES#;
|
|
|