KSEC_SEC_CFL_VW (SQL View)	Index Back
Security fields in Subrec LANGUAGE RELATED RECORD FOR KSEC_SEC_CF_VW

KSEC_SEC_CFL_VW

(SQL View)

Security fields in Subrec

LANGUAGE RELATED RECORD FOR KSEC_SEC_CF_VW

SELECT R.FIELDNAME , B.LANGUAGE_CD ,B.LONGNAME FROM PSRECFIELDDB R , PSDBFIELD F ,PSDBFLDLBLLNG_V B WHERE R.RECNAME='KSEC_SECFLD_WRK' AND R.FIELDNAME=F.FIELDNAME AND B.FIELDNAME=F.FIELDNAME AND F.FLDNOTUSED = 0

Related Language Record for KSEC_SEC_CF_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name