WP_PSHARING_MSG(SQL Table) |
Index Back |
|---|---|
Profit-Sharing Payroll MessageThis record is used to synchronize Profit-Sharing payments w/ Payroll system external to PeopleSoft. When Global Payroll France is installed and when employees are managed with Global Payroll (set into Job Data), positive inputs are created for Global Payroll and payments are processed by Global Payroll for France. If both conditions above are not met, communications with the payroll system are handled by publish/subscribe. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  WP_AGREEMENT_ID |
Character(5) | VARCHAR2(5) NOT NULL | Profit-Sharing: Agreement Identifier |
| 2 | PERIOD_ID |
Character(12) | VARCHAR2(12) NOT NULL | Time Period ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 6 | FROM_DATE |
Date(10) | DATE NOT NULL | From Date |
| 7 | THRU_DATE |
Date(10) | DATE NOT NULL | Thru Date |
| 8 | WP_GROSS_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Gross Amount |
| 9 | WP_NET_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Profit-Sharing Net Amount |
| 10 | WP_DEDUCTIONS_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Deductions on Interests |
| 11 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 13 | WP_FUND_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Profit-Sharing: This field determines the status of the related funds.
A=Available C=Cancelled E=Error N=Posted to Account P=Paid R=Request Payment S=Sent to Payroll T=Entitled X=Transfer to Account Default Value: R |
| 14 | WP_AMOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Amount Type
I=Interest P=Profit-Sharing |