PTCS_INSTANCEIDPTSF_CTX_FILTER(SQL View) |
Index Back |
|---|
| select PTCS_INSTANCEID,PTCS_PARAMETERNAME,PTCS_PNLFLDNAME FROM PSPTCS_MAPFLDS where PTCS_PARAMETERNAME IN ('field1','field2','field3','fieldval1','fieldval2','fieldval3') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTCS_INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | Instance ID |
| 2 | PTCS_PARAMETERNAME | Character(128) | VARCHAR2(128) NOT NULL | Parameter Name |
| 3 | PTCS_PNLFLDNAME | Character(254) | VARCHAR2(254) NOT NULL | Page Field Name |