RA_JOBINDCTR_VW (SQL View)	Index Back
xlat value items xlat value items for JOB INDICATOR used by profiles for selecting a values

RA_JOBINDCTR_VW

(SQL View)

xlat value items

xlat value items for JOB INDICATOR 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 = 'JOB_INDICATOR' 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_JOBINDCT_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job

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	JOB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned. N=Not Applicable P=Primary Job S=Secondary Job
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