eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.GHR_MASS_NOA_PREVIEW

Object Details

Object Name:	GHR_MASS_NOA_PREVIEW
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

GHR_MASS_NOA_PREVIEW table is used to show the Employee/Position Details for Mass NOA/Cancellation Actions

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MASS_NOA_PREVIEW_ID	NUMBER	(15)	Yes	Primary key generated from sequence GHR_MASS_NOA_PREVIEW_S
SESSION_ID	NUMBER	(9)	Yes	Session ID
EFFECTIVE_DATE	DATE			Effective Date
UI_TYPE	VARCHAR2	(10)	Yes	UI Type
MASS_ACTION_TYPE	VARCHAR2	(30)		Mass Action Type
PERSON_ID	NUMBER	(10)		Person Id
FULL_NAME	VARCHAR2	(240)		Full Name
NATIONAL_IDENTIFIER	VARCHAR2	(240)		SSN
EMPLOYEE_DATE_OF_BIRTH	DATE			Employee DOB
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number
POSITION_TITLE	VARCHAR2	(240)		Postion Title
POSITION_ID	NUMBER	(15)		Position ID
POSITION_NUMBER	VARCHAR2	(15)		Position Number
POSITION_SEQ_NO	NUMBER	(15)		Position Seq Number
NOA_CODE	VARCHAR2	(4)		NOA Code
AGENCY_CODE	VARCHAR2	(30)		Agency Code
TO_AGENCY_CODE	VARCHAR2	(30)		To Agency Code
OLD_ASSIGNMENT_STATUS	VARCHAR2	(80)		Old Assignment Status
NEW_ASSIGNMENT_STATUS	VARCHAR2	(80)		New Assignment Status
OLD_TYPE_OF_EMPLOYMENT	VARCHAR2	(30)		Old Type Of Employment
NEW_TYPE_OF_EMPLOYMENT	VARCHAR2	(30)		New Type of Employment
OLD_PAY_USERRA_STATUS	VARCHAR2	(30)		Old Pay USERRA Status
NEW_PAY_USERRA_STATUS	VARCHAR2	(30)		NEw Pay USERRA Status
DUTY_STATION_ID	NUMBER	(15)		Duty Station Id
DUTY_STATION_CODE	VARCHAR2	(9)		Duty Station Code
DUTY_STATION_DESC	VARCHAR2	(150)		Duty Station Desc
TO_DUTY_STATION_ID	NUMBER	(15)		To Duty Station Id
TO_DUTY_STATION_CODE	VARCHAR2	(9)		To Duty Station Code
TO_DUTY_STATION_DESC	VARCHAR2	(150)		To Duty Staion Desc
FROM_BASIC_PAY	NUMBER	(15)		From Basic Pay
TO_BASIC_PAY	NUMBER	(15)		To Basic Pay
FROM_LOCALITY_ADJ	NUMBER	(15)		From Locality Adj
TO_LOCALITY_ADJ	NUMBER	(15)		To Locality Adj
FROM_ADJ_BASIC_PAY	NUMBER	(15)		From Adjusted Basic Pay
TO_ADJ_BASIC_PAY	NUMBER	(15)		To Adjusted Basic Pay
FROM_TOTAL_SALARY	NUMBER	(15)		From Total Salary
TO_TOTAL_SALARY	NUMBER	(15)		To Total Salary
OCC_CODE	VARCHAR2	(30)		OCC Code
TO_OCC_CODE	VARCHAR2	(30)		To OCC Code
ORGANIZATION_ID	NUMBER	(15)		Organization Id
ORGANIZATION_NAME	VARCHAR2	(240)		Organization Name
PERSONNEL_OFFICE_ID	VARCHAR2	(4)		Personnel Office Id
POI_DESC	VARCHAR2	(80)		POI Desc
FROM_BARGAINING_UNIT_STATUS	VARCHAR2	(30)		From Bargaining Unit Status
TO_BARGAINING_UNIT_STATUS	VARCHAR2	(30)		To Bargaining Unit Status
FROM_FLSA_CATEGORY	VARCHAR2	(30)		From FLSA Category
TO_FLSA_CATEGORY	VARCHAR2	(30)		To FLSA Category
FROM_FUNCTIONAL_CLASS	VARCHAR2	(30)		From Functional Class
TO_FUNCTIONAL_CLASS	VARCHAR2	(30)		To Functional Class
SELECT_FLAG	VARCHAR2	(1)		Select Flag
FURLOUGH_INDICATOR	VARCHAR2	(1)		Furlough Indicator
OLD_LWOP_NTE_START_DATE	DATE			Old Lwop Nte Start Date
NEW_LWOP_NTE_START_DATE	DATE			New Lwop Nte Start Date
OLD_LWOP_NTE	DATE			Old Lwop Nte
NEW_LWOP_NTE	DATE			New Lwop Nte
OLD_FURLOUGH_NTE_START_DATE	DATE			Old Furlough Nte Start Date
NEW_FURLOUGH_NTE_START_DATE	DATE			New Furlough Nte Start Date
OLD_FURLOUGH_NTE	DATE			Old Furlough Nte
NEW_FURLOUGH_NTE	DATE			New Furlough Nte
USER_ATTRIBUTE1	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE2	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE3	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE4	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE5	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE6	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE7	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE8	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE9	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE10	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE11	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE12	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE13	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE14	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE15	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE16	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE17	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE18	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE19	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE20	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE21	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE22	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE23	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE24	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE25	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE26	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE27	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE28	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE29	VARCHAR2	(255)		Descriptive flexfield column
USER_ATTRIBUTE30	VARCHAR2	(255)		Descriptive flexfield column
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column.
CREATED_BY	NUMBER	(15)		Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column.

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 does not reference any database object

HR.GHR_MASS_NOA_PREVIEW is referenced by following:

HR: GHR_MASS_NOA_PREVIEW#