RA_HRSTAT_VW (SQL View)	Index Back
xlat value items xlat value items for HUMAN RESOURCE STATUS used by profiles for selecting a values

RA_HRSTAT_VW

(SQL View)

xlat value items

xlat value items for HUMAN RESOURCE STATUS used by profiles for selecting a values

SELECT %Substring(A.FIELDVALUE,1,1) , A.FIELDNAME , A.XLATLONGNAME , A.XLATSHORTNAME 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_HRSTAT_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

4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short 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
4	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name