EOEP_PRCFLDP_VW (SQL View)	Index Back
Valid price flds using Parent This view extracts the record and fieldname of the application code but using the parent key code.

EOEP_PRCFLDP_VW

(SQL View)

Valid price flds using Parent

This view extracts the record and fieldname of the application code but using the parent key code.

SELECT FLD.EOEP_APP_CD , FLD.RECNAME , FLD.FIELDNAME , FLD.PROMPT_TBL , PAR.EOEP_KEY_FLD_CD FROM PS_EOEP_FLDNAME_VW FLD , PS_EOEP_PRCFLD_VW PAR WHERE FLD.FIELDNAME = PAR.FIELDNAME AND PAR.EOEP_APP_CD = ( SELECT X.EOEP_PARENT_APP FROM PS_EOEP_APP_CODE X WHERE X.EOEP_APP_CD = FLD.EOEP_APP_CD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code
Prompt Table: EOEP_APPCD_VW

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

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

4 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table
Prompt Table: PSRECDEFN

5 EOEP_KEY_FLD_CD Character(3) VARCHAR2(3) NOT NULL Key field code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEP_APP_CD	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code Prompt Table: EOEP_APPCD_VW
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	PROMPT_TBL	Character(15)	VARCHAR2(15) NOT NULL	Prompt Table Prompt Table: PSRECDEFN
5	EOEP_KEY_FLD_CD	Character(3)	VARCHAR2(3) NOT NULL	Key field code