GP_ENTRY_TYPE(SQL Table) |
Index Back |
|---|---|
Element Entry TypeElement Entry Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ENTRY_TYPE_ID |
Character(3) | VARCHAR2(3) NOT NULL | Element Entry Type ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | VALUE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Value Type
C=Character D=Calendar Date I=Integer N=Numeric P=Element Name X=Not Applicable Default Value: P |
| 5 | PROMPTVIEW | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt View
Prompt Table: GP_PIN_RECS_VW |
| 6 | PROMPTVIEW_PE | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt View - Pay Entity
Prompt Table: GP_PIN_RECS_VW |
| 7 | PROMPTVIEW_PG | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt View - Paygroup
Prompt Table: GP_PIN_RECS_VW |
| 8 | PROMPTVIEW_CAL | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt VIew - Calendar
Prompt Table: GP_PIN_RECS_VW |
| 9 | PROMPTVIEW_PYE | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt View - Payee
Prompt Table: GP_PIN_RECS_VW |
| 10 | PROMPTVIEW_PI | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt View - Positive Input
Prompt Table: GP_PIN_RECS_VW |
| 11 | PROMPTVIEW_ELEM | Character(18) | VARCHAR2(18) NOT NULL |
Element Entry Prompt View - Via Element
Prompt Table: GP_PIN_RECS_VW |
| 12 | PROMPTVIEW_SOVR | Character(18) | VARCHAR2(18) NOT NULL |
This is a field for Earning/Deduction/Absence Level Override view
Prompt Table: GP_PIN_RECS_VW |