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

RA_JOBHRSTA_LVW

(SQL View)

xlat value items

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

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

Related Language Record for RA_JOBHRSTAT_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

4 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name