PTS_RECFLD_VW

(SQL View)
 Index Back

Record Field View

Record Field View to identify the Search Keys, Keys, Alt Srch Keys

SELECT A.RECNAME , A.FIELDNAME , B.FIELDTYPE , A.LABEL_ID , A.FIELDNUM , CASE WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 2048)=2048 THEN 'Y' ELSE 'N' END AS SEARCH_KEY , CASE WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 2048)=2048 OR %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 16)=16 THEN 'Y' ELSE 'N' END AS CRITERIA , CASE WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 32)=32 THEN 'Y' ELSE 'N' END AS RESULT , CASE WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 8192)=8192 THEN 4 WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 16384)=16384 AND A.EDITTABLE NOT LIKE '%EDITTABLE%' THEN 2 WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 16384)=16384 AND A.EDITTABLE LIKE '%EDITTABLE%' THEN 0 WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 512)=512 THEN 3 ELSE 1 END AS EDIT_TYPE , CASE WHEN A.EDITTABLE LIKE '%EDITTABLE%' THEN ' ' ELSE A.EDITTABLE END AS EDITTABLE , A.SETCNTRLFLD ,A.DEFRECNAME ,A.DEFFIELDNAME , CASE WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 268435712)=268435712 THEN 'Y' ELSE 'N' END AS REQUIRED FROM PSRECFIELDDB A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
4 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
5 PTS_FIELD_ORDER Number(3,0) SMALLINT NOT NULL Criteria/Results Field Order
6 PTS_SRCH_KEY_FLG Character(1) VARCHAR2(1) NOT NULL Search Key field flag
7 PTS_INCL_IN_CRIT Character(1) VARCHAR2(1) NOT NULL Include the selected field in Search Criteria

Y/N Table Edit

Default Value: N

8 PTS_INCL_IN_RSLT Character(1) VARCHAR2(1) NOT NULL Include the selected field in Search Results

Y/N Table Edit

Default Value: N

9 PTS_PRMP_EDITTYPE Character(1) VARCHAR2(1) NOT NULL Promopt Edit Type
0=No Prompt Edit
1=No Table Edit
2=Prompt Table
3=Translate Table
4=Yes/No
10 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

Prompt Table: PSRECDEFN

11 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name

Prompt Table: PSRECFIELDDB

12 DEFRECNAME Character(15) VARCHAR2(15) NOT NULL Default Record Name
13 DEFFIELDNAME Character(18) VARCHAR2(18) NOT NULL Default Field Name
14 PTS_REQUIRED Character(1) VARCHAR2(1) NOT NULL Include the selected field in Search Criteria