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]

VIEW: APPS.PQP_ASSIGNMENT_ATTRIBUTES_D

Object Details

Object Name:	PQP_ASSIGNMENT_ATTRIBUTES_D
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQP.PQP_ASSIGNMENT_ATTRIBUTES_D
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for DateTrack history of the table PQP_ASSIGNMENT_ATTRIBUTES_F

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ATTRIBUTE_ID	NUMBER	(15)	Yes	System generated primary key
EFFECTIVE_START_DATE	DATE		Yes	Effective Start Date
EFFECTIVE_END_DATE	DATE		Yes	Effective end date
CONTRACT_TYPE	VARCHAR2	(80)		Name of contract type
WORK_PATTERN	VARCHAR2	(80)		Name of work pattern
START_DAY	VARCHAR2	(30)		Start day in work pattern
TP_JOB_STATUS	VARCHAR2	(80)		Indicates whether a person is a Teacher
TP_SAFEGUARDED_GRADE	VARCHAR2	(150)		Indictates the safeguarded grade of a teacher
TP_SAFEGUARDED_RATE_TYPE	VARCHAR2	(30)		Indictates whether the safeguarded rate of the teacher is a grade rate or scale rate
TP_SAFEGUARDED_RATE_NAME	VARCHAR2	(80)		Indictates the safeguarded grade or scale rate name of a teacher
TP_SAFEGUARDED_SPINAL_POINT	VARCHAR2	(30)		Indictates the safeguarded spinal point of a teacher
TP_ELECTED_PENSION	VARCHAR2	(30)		Indictates whether the person has Elected a Pension Scheme
TP_FAST_TRACK	VARCHAR2	(30)		Indictates whether the teacher is on a Fast Track career path
TP_HEADTEACHER_GRP_CODE	NUMBER	(15)		Indicates the protected location group code of a head teacher
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	VARCHAR2	(100)		Standard Who column
LGPS_PROCESS_FLAG	VARCHAR2	(30)		Indicates the status of the assignment for LGPS
LGPS_EXCLUSION_TYPE	VARCHAR2	(80)		Indicates the reason for Exclusion from LGPS
LGPS_PENSIONABLE_PAY	VARCHAR2	(60)		This will have the Contractual pensionable pay for the assignment
LGPS_TRANS_ARRANG_FLAG	VARCHAR2	(30)		Indicates if the assignment is in transitional arrangement or not.
LGPS_MEMBERSHIP_NUMBER	VARCHAR2	(60)		LGPS Pension Membership number can be entered here.

Query Text

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


SELECT ASSIGNMENT_ATTRIBUTE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CONTRACT_TYPE
,      WORK_PATTERN
,      START_DAY
,      TP_JOB_STATUS
,      TP_SAFEGUARDED_GRADE
,      TP_SAFEGUARDED_RATE_TYPE
,      TP_SAFEGUARDED_RATE_NAME
,      TP_SAFEGUARDED_SPINAL_POINT
,      TP_ELECTED_PENSION
,      TP_FAST_TRACK
,      TP_HEADTEACHER_GRP_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LGPS_PROCESS_FLAG
,      LGPS_EXCLUSION_TYPE
,      LGPS_PENSIONABLE_PAY
,      LGPS_TRANS_ARRANG_FLAG
,      LGPS_MEMBERSHIP_NUMBER
FROM APPS.PQP_ASSIGNMENT_ATTRIBUTES_D;

Dependencies

[top of page]

APPS.PQP_ASSIGNMENT_ATTRIBUTES_D references the following:

APPS: FND_USER_VIEW; HR_API - show dependent code; HR_LOOKUPS; PAY_RATES; PAY_USER_TABLES; PER_SPINAL_POINTS; PQP_ASSIGNMENT_ATTRIBUTES_F; PQP_VEHICLE_DETAILS

APPS.PQP_ASSIGNMENT_ATTRIBUTES_D is not referenced by any database object