PTS_AD_RECFL_VW(SQL View) |
Index Back |
|---|---|
Record Field ViewRecord Field View to identify the Search Keys, Keys, Alt Srch Keys |
| SELECT A.RECNAME , A.FIELDNAME , B.FIELDTYPE , A.LABEL_ID , A.FIELDNUM , 'N' ,'N' ,'N' , CASE WHEN %Sql(PTS_BITAND_ALL_PLATFORMS, A.USEEDIT, 2048)=2048 THEN 'Y' ELSE 'N' END AS SEARCH_KEY ,0 , 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, 2304)=2304 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_USE_IN_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 7 | PTS_ADD_FLD_GREY | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 8 | PTS_ADD_FLD_VISIB | Character(1) | VARCHAR2(1) NOT NULL |
Include the selected field in Search Criteria
Y/N Table Edit Default Value: N |
| 9 | PTS_SRCH_KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Key field flag
Y/N Table Edit |
| 10 | PTS_ADD_ORDER | Number(3,0) | SMALLINT NOT NULL | Criteria/Results Field Order |
| 11 | 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 |
| 12 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table: PSRECDEFN |
| 13 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table: PSRECFIELDDB |
| 14 | DEFRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Default Record Name |
| 15 | DEFFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Default Field Name |
| 16 | PTS_DEF_VALUE | Character(18) | VARCHAR2(18) NOT NULL | Default Field Name |
| 17 | PTS_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Include the selected field in Search Criteria |