RA_JOBHRSTAT_VW (SQL View)	Index Back
xlat value items xlat value items for JOB HR STATUS used by profiles for selecting a values

RA_JOBHRSTAT_VW

(SQL View)

xlat value items

xlat value items for JOB HR STATUS used by profiles for selecting a values

SELECT %Substring(A.FIELDVALUE,1,1) , A.FIELDNAME , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'HR_STATUS' AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PSXLATITEM AA WHERE A.FIELDNAME = AA.FIELDNAME AND A.FIELDVALUE = AA.FIELDVALUE AND AA.EFFDT <= %CurrentDateIn)

Related Language Record: RA_JOBHRSTA_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_STATUS Character(1) VARCHAR2(1) NOT NULL An indication whether a worker is still on payroll. HR_STATUS = "A" if EMPL_STATUS in ("A", "L", "P", "S", "W"); HR_STATUS = "A" if EMPL_STATUS not in ("A", "L", "P", "S", "W");
A=Active
I=Inactive

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	An indication whether a worker is still on payroll. HR_STATUS = "A" if EMPL_STATUS in ("A", "L", "P", "S", "W"); HR_STATUS = "A" if EMPL_STATUS not in ("A", "L", "P", "S", "W"); A=Active I=Inactive
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name