HCR_POSDTAG_LNI (SQL View)	Index Back
Position Data RelLng Interf V Comercial Position Data Related Language Interface View

HCR_POSDTAG_LNI

(SQL View)

Position Data RelLng Interf V

Comercial Position Data Related Language Interface View

SELECT A.POSITION_NBR , A.LANGUAGE_CD , A.EFFDT , A.GVT_ORG_TTL_DESCR FROM PS_POSN_DATA_LANG A

Related Language Record for HCR_POS_DTA_G_I HRS_POS_DTA_G_1 HRS_POS_DTA_G_I HRS_POS_DT_G_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Default Value: 0

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Default Value: 0
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	GVT_ORG_TTL_DESCR	Character(70)	VARCHAR2(70) NOT NULL	Organization Position Title