HR_PRTR_POSN_VW (SQL View)	Index Back
Promote Transfer Position Data HTML Email Approval Promote and Transfer position data.

HR_PRTR_POSN_VW

(SQL View)

Promote Transfer Position Data

HTML Email Approval Promote and Transfer position data.

SELECT P.POSITION_NBR , P.FULL_PART_TIME , P.STD_HOURS , P.DESCR , X.XLATLONGNAME FROM %Table(POSITION_DATA) P , PSXLATITEM X WHERE %EffdtCheck(POSITION_DATA P1, P, %CurrentDateIn) AND P.EFF_STATUS = 'A' AND X.FIELDNAME = 'FULL_PART_TIME' AND X.FIELDVALUE = P.FULL_PART_TIME AND %EffdtCheck(PSXLATITEM X1, X, %Currentdatein) AND X.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

2 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

3 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
3	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name