ENTRY_PRMPT_IDRECNAMEFIELDNAMEGP_ENTRY_PRM_VW(SQL View) |
Index Back |
|---|---|
Element Entry Parameter ViewGlobal Payroll - Element Entry Parameter view record. |
| SELECT A.ENTRY_PRMPT_ID, B.RECNAME, B.FIELDNAME FROM PS_GP_ENTRY_PRMPT1 A, PSRECFIELD B WHERE A.ENTRY_PRMPT_ID = B.EDITTABLE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ENTRY_PRMPT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Element Entry Prompt ID |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |