| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %DATE
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
TAX_SCALE |
Character(3) |
VARCHAR2(3) NOT NULL |
Sal Package - Tax Scale
Prompt Table:
%EDITTABLE
|
| 6 |
PKG_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sal Package - Package Template ID
Prompt Table:
PKG_TMP_TBL
|
| 7 |
PKG_RULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sal Package - Package Rule ID
Prompt Table:
PKG_RULE_TBL
|
| 8 |
PKG_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal package - Package Method
B=Bottom Up
M=Middle Out
T=Top Down
Default Value: B
|
| 9 |
TEC_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Target Total Employment Cost
|
| 10 |
TEC_CURRENT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Current Total Employment Cost
|
| 11 |
TEC_BALANCE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Balance Total Employment Cost
|
| 12 |
TPV_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Target Total Package Value
|
| 13 |
TPV_CURRENT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Current Total Package Value
|
| 14 |
TPV_BALANCE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Balance Total Package Value
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
GROSS_SALARY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Gross Salary
|
| 17 |
PKG_CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Package Confirmed
Y/N Table Edit
Default Value: N
|
| 18 |
PKG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - Package Status
C=Current
H=History
P=Proposed
Default Value: P
|
| 19 |
PAYROLL_STATE_AUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Sal Package - Payroll Tax State
Prompt Table:
PKG_PYTX_RT_TBL
|
| 20 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 21 |
PKG_START_DT |
Date(10) |
DATE |
Sal pacakge - Package Start Date
|
| 22 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 23 |
TAX_YEARLY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal package - Tax Yearly
|
| 24 |
PKG_DEENROLLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Sal Package - De-enrolled
Y/N Table Edit
Default Value: N
|
| 25 |
PKG_END_DT |
Date(10) |
DATE NOT NULL |
Sal package - Package End Date
|
| 26 |
CF_TEC_PER_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal package - C/F TEC Target (Period)
|
| 27 |
CF_TEC_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - C/F TEC Target (Annual)
|
| 28 |
CF_TPV_PER_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - C/F TPV Target (Period)
|
| 29 |
CF_TPV_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - C/F TPV Target (Annual)
|
| 30 |
TEC_PER_BALANCE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package -Rem Balance TEC (Cur Period)
|
| 31 |
TEC_PER_CURRENT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Total TEC (Cur Period)
|
| 32 |
TEC_PER_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Target TEC (Cur Period)
|
| 33 |
TPV_PER_BALANCE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - TPV Balance (Cur Period)
|
| 34 |
TPV_PER_CURRENT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Total TPV (Cur Period)
|
| 35 |
TPV_PER_TARGET |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Sal Package - Non-Packaged Components
|
| 36 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
Set Control Field: COMPANY
|
| 37 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
HR_GP_PYGRP_VW
|
| 38 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 39 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 40 |
CREATEDTTM |
DateTime(26) |
TIMESTAMP |
DateTime of Query Creation
|
| 41 |
CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 42 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 43 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|