OPRIDGPUS_PIN_CAL_NUMGPUS_PIN_VAR_NUMPrompt Table: GPUS_VR_VW
1=Character
2=Date
3=Monetary
4=Decimal
5=Element Pointer
6=Not Applicable
GPUS_CALMVR_VW(SQL View) |
Index Back |
|---|---|
GPUS_DE_VWGPUS_DE_VW |
| %Sql(GPUS_GRN_PINVR_SQL, 'VR', 'GIN','GOR') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | GPUS_PIN_CAL_NUM |
Number(8,0) | INTEGER NOT NULL | Calculation Formula PIN Number |
| 3 | GPUS_PIN_VAR_NUM |
Number(8,0) | INTEGER NOT NULL |
Variable PIN Number
Prompt Table: GPUS_VR_VW |
| 4 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | FLD_FMT | Character(1) | VARCHAR2(1) NOT NULL |
Field format for Global Payroll elements
1=Character 2=Date 3=Monetary 4=Decimal 5=Element Pointer 6=Not Applicable |