CHKLSTITMVW2LNG

(SQL View)

SELECT A.CHKLST_ITEM_CD ,A.LANGUAGE_CD , A.DESCRLONG FROM PS_SCC_CKLSITM_LNG A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SCC_CKLSITM_LNG A1 WHERE A1.CHKLST_ITEM_CD = A.CHKLST_ITEM_CD AND A1.EFFDT <= %CurrentDateIn)

Related Language Record for CHKLST_ITEM_VW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code

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

3 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHKLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Item Code
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCRLONG	Long Character	CLOB	Long Description