Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.GHR_MASS_NOA_PREVIEW#

Object Details
Object Name: GHR_MASS_NOA_PREVIEW#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MASS_NOA_PREVIEW_ID NUMBER (15) Yes
SESSION_ID NUMBER (9) Yes
EFFECTIVE_DATE DATE

UI_TYPE VARCHAR2 (10) Yes
MASS_ACTION_TYPE VARCHAR2 (30)
PERSON_ID NUMBER (10)
FULL_NAME VARCHAR2 (240)
NATIONAL_IDENTIFIER VARCHAR2 (240)
EMPLOYEE_DATE_OF_BIRTH DATE

EMPLOYEE_NUMBER VARCHAR2 (30)
POSITION_TITLE VARCHAR2 (240)
POSITION_ID NUMBER (15)
POSITION_NUMBER VARCHAR2 (15)
POSITION_SEQ_NO NUMBER (15)
NOA_CODE VARCHAR2 (4)
AGENCY_CODE VARCHAR2 (30)
TO_AGENCY_CODE VARCHAR2 (30)
OLD_ASSIGNMENT_STATUS VARCHAR2 (80)
NEW_ASSIGNMENT_STATUS VARCHAR2 (80)
OLD_TYPE_OF_EMPLOYMENT VARCHAR2 (30)
NEW_TYPE_OF_EMPLOYMENT VARCHAR2 (30)
OLD_PAY_USERRA_STATUS VARCHAR2 (30)
NEW_PAY_USERRA_STATUS VARCHAR2 (30)
DUTY_STATION_ID NUMBER (15)
DUTY_STATION_CODE VARCHAR2 (9)
DUTY_STATION_DESC VARCHAR2 (150)
TO_DUTY_STATION_ID NUMBER (15)
TO_DUTY_STATION_CODE VARCHAR2 (9)
TO_DUTY_STATION_DESC VARCHAR2 (150)
FROM_BASIC_PAY NUMBER (15)
TO_BASIC_PAY NUMBER (15)
FROM_LOCALITY_ADJ NUMBER (15)
TO_LOCALITY_ADJ NUMBER (15)
FROM_ADJ_BASIC_PAY NUMBER (15)
TO_ADJ_BASIC_PAY NUMBER (15)
FROM_TOTAL_SALARY NUMBER (15)
TO_TOTAL_SALARY NUMBER (15)
OCC_CODE VARCHAR2 (30)
TO_OCC_CODE VARCHAR2 (30)
ORGANIZATION_ID NUMBER (15)
ORGANIZATION_NAME VARCHAR2 (240)
PERSONNEL_OFFICE_ID VARCHAR2 (4)
POI_DESC VARCHAR2 (80)
FROM_BARGAINING_UNIT_STATUS VARCHAR2 (30)
TO_BARGAINING_UNIT_STATUS VARCHAR2 (30)
FROM_FLSA_CATEGORY VARCHAR2 (30)
TO_FLSA_CATEGORY VARCHAR2 (30)
FROM_FUNCTIONAL_CLASS VARCHAR2 (30)
TO_FUNCTIONAL_CLASS VARCHAR2 (30)
SELECT_FLAG VARCHAR2 (1)
FURLOUGH_INDICATOR VARCHAR2 (1)
OLD_LWOP_NTE_START_DATE DATE

NEW_LWOP_NTE_START_DATE DATE

OLD_LWOP_NTE DATE

NEW_LWOP_NTE DATE

OLD_FURLOUGH_NTE_START_DATE DATE

NEW_FURLOUGH_NTE_START_DATE DATE

OLD_FURLOUGH_NTE DATE

NEW_FURLOUGH_NTE DATE

USER_ATTRIBUTE1 VARCHAR2 (255)
USER_ATTRIBUTE2 VARCHAR2 (255)
USER_ATTRIBUTE3 VARCHAR2 (255)
USER_ATTRIBUTE4 VARCHAR2 (255)
USER_ATTRIBUTE5 VARCHAR2 (255)
USER_ATTRIBUTE6 VARCHAR2 (255)
USER_ATTRIBUTE7 VARCHAR2 (255)
USER_ATTRIBUTE8 VARCHAR2 (255)
USER_ATTRIBUTE9 VARCHAR2 (255)
USER_ATTRIBUTE10 VARCHAR2 (255)
USER_ATTRIBUTE11 VARCHAR2 (255)
USER_ATTRIBUTE12 VARCHAR2 (255)
USER_ATTRIBUTE13 VARCHAR2 (255)
USER_ATTRIBUTE14 VARCHAR2 (255)
USER_ATTRIBUTE15 VARCHAR2 (255)
USER_ATTRIBUTE16 VARCHAR2 (255)
USER_ATTRIBUTE17 VARCHAR2 (255)
USER_ATTRIBUTE18 VARCHAR2 (255)
USER_ATTRIBUTE19 VARCHAR2 (255)
USER_ATTRIBUTE20 VARCHAR2 (255)
USER_ATTRIBUTE21 VARCHAR2 (255)
USER_ATTRIBUTE22 VARCHAR2 (255)
USER_ATTRIBUTE23 VARCHAR2 (255)
USER_ATTRIBUTE24 VARCHAR2 (255)
USER_ATTRIBUTE25 VARCHAR2 (255)
USER_ATTRIBUTE26 VARCHAR2 (255)
USER_ATTRIBUTE27 VARCHAR2 (255)
USER_ATTRIBUTE28 VARCHAR2 (255)
USER_ATTRIBUTE29 VARCHAR2 (255)
USER_ATTRIBUTE30 VARCHAR2 (255)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MASS_NOA_PREVIEW_ID
,      SESSION_ID
,      EFFECTIVE_DATE
,      UI_TYPE
,      MASS_ACTION_TYPE
,      PERSON_ID
,      FULL_NAME
,      NATIONAL_IDENTIFIER
,      EMPLOYEE_DATE_OF_BIRTH
,      EMPLOYEE_NUMBER
,      POSITION_TITLE
,      POSITION_ID
,      POSITION_NUMBER
,      POSITION_SEQ_NO
,      NOA_CODE
,      AGENCY_CODE
,      TO_AGENCY_CODE
,      OLD_ASSIGNMENT_STATUS
,      NEW_ASSIGNMENT_STATUS
,      OLD_TYPE_OF_EMPLOYMENT
,      NEW_TYPE_OF_EMPLOYMENT
,      OLD_PAY_USERRA_STATUS
,      NEW_PAY_USERRA_STATUS
,      DUTY_STATION_ID
,      DUTY_STATION_CODE
,      DUTY_STATION_DESC
,      TO_DUTY_STATION_ID
,      TO_DUTY_STATION_CODE
,      TO_DUTY_STATION_DESC
,      FROM_BASIC_PAY
,      TO_BASIC_PAY
,      FROM_LOCALITY_ADJ
,      TO_LOCALITY_ADJ
,      FROM_ADJ_BASIC_PAY
,      TO_ADJ_BASIC_PAY
,      FROM_TOTAL_SALARY
,      TO_TOTAL_SALARY
,      OCC_CODE
,      TO_OCC_CODE
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      PERSONNEL_OFFICE_ID
,      POI_DESC
,      FROM_BARGAINING_UNIT_STATUS
,      TO_BARGAINING_UNIT_STATUS
,      FROM_FLSA_CATEGORY
,      TO_FLSA_CATEGORY
,      FROM_FUNCTIONAL_CLASS
,      TO_FUNCTIONAL_CLASS
,      SELECT_FLAG
,      FURLOUGH_INDICATOR
,      OLD_LWOP_NTE_START_DATE
,      NEW_LWOP_NTE_START_DATE
,      OLD_LWOP_NTE
,      NEW_LWOP_NTE
,      OLD_FURLOUGH_NTE_START_DATE
,      NEW_FURLOUGH_NTE_START_DATE
,      OLD_FURLOUGH_NTE
,      NEW_FURLOUGH_NTE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      USER_ATTRIBUTE26
,      USER_ATTRIBUTE27
,      USER_ATTRIBUTE28
,      USER_ATTRIBUTE29
,      USER_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
FROM HR.GHR_MASS_NOA_PREVIEW#;

Dependencies

[top of page]

HR.GHR_MASS_NOA_PREVIEW# references the following:

SchemaHR
TableGHR_MASS_NOA_PREVIEW
HR.GHR_MASS_NOA_PREVIEW# is referenced by following:

SchemaAPPS
SynonymGHR_MASS_NOA_PREVIEW
TriggerGHR_MASS_NOA_PREVIEW_WHO