GPSC_ERC_CMPEVW(SQL View) |
Index Back |
---|---|
EB Compare ViewElement Browser Compare View |
SELECT B.OPRID , B.PIN_NUM_TGT , C.PIN_CODE , C.PIN_NM , C.PIN_TYPE , C.DESCR , C.FLD_FMT , C.DEFN_ASOFDT_OPTN , C.CHECK_GENER_IND , C.RECALC_IND , C.USED_BY , C.COUNTRY , C.PIN_CATEGORY , C.PIN_INDUSTRY , C.PIN_OWNER , C.PIN_CLASS , C.OVRD_IND_CAL , C.OVRD_IND_PYENT , C.OVRD_IND_PG , C.OVRD_IND_PYE , C.OVRD_IND_PI , C.OVRD_IND_ELEM , C.OVRD_IND_SOVR , C.STORE_RSLT , C.STORE_RSLT_IF_ZERO , C.PIN_PARENT_NUM , C.PIN_CUSTOM1 , C.PIN_CUSTOM2 , C.PIN_CUSTOM3 , C.PIN_CUSTOM4 , C.PIN_CUSTOM5 , C.FCST_IND , C.FCST_REQ_IND , C.PIN_DRIVER_NUM , C.ENTRY_TYPE_USER_F1 , C.PIN_USER_FLD1_NUM , C.ENTRY_TYPE_USER_F2 , C.PIN_USER_FLD2_NUM , C.ENTRY_TYPE_USER_F3 , C.PIN_USER_FLD3_NUM , C.ENTRY_TYPE_USER_F4 , C.PIN_USER_FLD4_NUM , C.ENTRY_TYPE_USER_F5 , C.PIN_USER_FLD5_NUM , C.ENTRY_TYPE_USER_F6 , C.PIN_USER_FLD6_NUM , C.RTO_DELTA_UF_LVL , C.LAST_UPDT_DTTM , C.LAST_UPDT_OPRID , C.AUTO_ASSIGNED_TYPE , C.GP_VERSION , C.COMMENTS FROM PS_GPSC_ERC_CMPELM B , PS_GP_PIN C WHERE B.PIN_NUM = C.PIN_NUM |
# | 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
Default Value: 999999 |
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 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
5 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Element Type
Prompt Table: GP_PIN_TYPE |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | 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 |
8 | DEFN_ASOFDT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
DEFN_ASOFDT_OPTN
B=Calendar Period Begin Date E=Calendar Period End Date N=Not Applicable P=Payment Date R=Process Begin Date S=Process End Date |
9 | CHECK_GENER_IND | Character(1) | VARCHAR2(1) NOT NULL | Check Generation Indicator |
10 | RECALC_IND | Character(1) | VARCHAR2(1) NOT NULL |
Always Recalculate indicator
Y/N Table Edit |
11 | USED_BY | Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country |
12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
13 | PIN_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL |
Element Category
Prompt Table: GP_PIN_CATEGORY |
14 | PIN_INDUSTRY | Character(4) | VARCHAR2(4) NOT NULL |
Element Industry
Prompt Table: GP_PIN_INDUSTRY |
15 | 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 |
16 | PIN_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Element Class
CU=Customary NC=Not Classified SM=Sample Data ST=Statutory SY=System Data |
17 | OVRD_IND_CAL | Character(1) | VARCHAR2(1) NOT NULL |
Calendar Level Override Ind
Y/N Table Edit |
18 | OVRD_IND_PYENT | Character(1) | VARCHAR2(1) NOT NULL |
Pay Entity Override Ind
Y/N Table Edit |
19 | OVRD_IND_PG | Character(1) | VARCHAR2(1) NOT NULL |
Pay Group Override Indicator
Y/N Table Edit |
20 | OVRD_IND_PYE | Character(1) | VARCHAR2(1) NOT NULL |
Payee Level Override Indicator
Y/N Table Edit |
21 | OVRD_IND_PI | Character(1) | VARCHAR2(1) NOT NULL |
Positive Input Override Ind
Y/N Table Edit |
22 | OVRD_IND_ELEM | Character(1) | VARCHAR2(1) NOT NULL |
Element Level Override Ind
Y/N Table Edit |
23 | OVRD_IND_SOVR | Character(1) | VARCHAR2(1) NOT NULL | This field is used on GP_PIN page to determine if any element definition overrides are allowed |
24 | STORE_RSLT | Character(1) | VARCHAR2(1) NOT NULL |
Store Results
Y/N Table Edit |
25 | STORE_RSLT_IF_ZERO | Character(1) | VARCHAR2(1) NOT NULL |
Store Results if Zero
N=If Element Or Comp Is Non-Zero X=If Element Is Non-Zero Y=Always Store Y/N Table Edit |
26 | PIN_PARENT_NUM | Number(8,0) | INTEGER NOT NULL | Parent Element Number |
27 | PIN_CUSTOM1 | Character(20) | VARCHAR2(20) NOT NULL | Customer FIelds |
28 | PIN_CUSTOM2 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM2 |
29 | PIN_CUSTOM3 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM3 fields |
30 | PIN_CUSTOM4 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM4 |
31 | PIN_CUSTOM5 | Character(20) | VARCHAR2(20) NOT NULL | PIN_CUSTOM5 |
32 | FCST_IND | Character(1) | VARCHAR2(1) NOT NULL | This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting. |
33 | FCST_REQ_IND | Character(1) | VARCHAR2(1) NOT NULL | The field is used on GP_PIN to indicate whether forecasting is required for this element. |
34 | PIN_DRIVER_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
35 | ENTRY_TYPE_USER_F1 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
36 | PIN_USER_FLD1_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
37 | ENTRY_TYPE_USER_F2 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
38 | PIN_USER_FLD2_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
39 | ENTRY_TYPE_USER_F3 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
40 | PIN_USER_FLD3_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
41 | ENTRY_TYPE_USER_F4 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
42 | PIN_USER_FLD4_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
43 | ENTRY_TYPE_USER_F5 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
44 | PIN_USER_FLD5_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
45 | ENTRY_TYPE_USER_F6 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
46 | PIN_USER_FLD6_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number |
47 | RTO_DELTA_UF_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Used to defined what user fields to consider when summing retro or deltas
0=None 1=Through User Field 1 2=Through User Field 2 3=Through User Field 3 4=Through User Field 4 5=Through User Field 5 A=All User Fields Defined |
48 | LAST_UPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated Date-Time Stamp |
49 | LAST_UPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated User Name |
50 | AUTO_ASSIGNED_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Auto-Assigned Element Type
AR=Add to Arrears BS=Base NT=Amount Not Taken PB=Payback PC=Percent RT=Rate UN=Unit |
51 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |
52 | COMMENTS | Long Character | CLOB | Comment |