SCP_POA_SCHD_LN (SQL View)	Index Back
Schedule Add Information View POA Additional Schedule Information

SCP_POA_SCHD_LN

(SQL View)

Schedule Add Information View

POA Additional Schedule Information

SELECT A.FIELDNAME , B.LABEL_ID ,C.LANGUAGE_CD , C.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B , PSDBFLDLABLLANG C WHERE A.RECNAME = 'SCP_POA_SCHD_WK' AND A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND B.LABEL_ID = C.LABEL_ID AND B.FIELDNAME = C.FIELDNAME

Related Language Record for SCP_POA_SCHD_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

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

4 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	FIELDLABEL	Character(60)	VARCHAR2(60) NOT NULL	Field Label