OPRIDPIN_NUMPrompt Table: GP_PINTYPE_VW
C=Customer Maintained
M=PS Delivered/Customer Modified
N=PS Delivered / Not Maintained
P=PS Delivered / Maintained
S=PS Delivered/Maintained/Secure
GPSC_ERC_CMPELM(SQL Table) |
Index Back |
|---|---|
Package ElementsGlobal Payroll Package Elements Record. |
| # | 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 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 6 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Element Type
Prompt Table: GP_PINTYPE_VW |
| 7 | PIN_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Element Owner
C=Customer Maintained M=PS Delivered/Customer Modified N=PS Delivered / Not Maintained P=PS Delivered / Maintained S=PS Delivered/Maintained/Secure |
| 8 | PIN_NUM_TGT | Number(8,0) | INTEGER NOT NULL | Element number [PIN] field |