| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 2 |
AUDIT_STAMP |
DateTime(26) |
TIMESTAMP NOT NULL |
Date and Time Stamp
|
| 3 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 4 |
AUDIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Flag
A=After
B=Before
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 6 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 7 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
GENL_DED_CD
|
| 8 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 9 |
DED_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Calculation Routine
A=Flat Amount
B=Percentage
C=Calculated by Salary System
D=Default to Deduction Table
E=Percent of Special Earnings
F=Percent of Federal Gross
G=Percent of Total Gross
H=Rate x Total Hours
N=Percent of Net Pay
P=Rate x Special Hours
S=Special Deduction Calculation
W=Rate x Hours Worked
|
| 10 |
DEDUCTION_END_DT |
Date(10) |
DATE |
Deduction End Date
|
| 11 |
DED_ADDL_AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Deduction Flat/Addl Amount
|
| 12 |
DED_RATE_PCT |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Deduction Rate/Percent
|
| 13 |
GOAL_AMT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Goal Amount
|
| 14 |
GOAL_BAL |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Goal Balance
|
| 15 |
LOAN_INT_PCT |
Number(6,3) |
DECIMAL(5,3) NOT NULL |
Loan Interest Percent
|
| 16 |
BAS_TAXABLE_BEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Ben Admin Taxable Ben (Canada)
Default Value: N
|
| 17 |
DED_STOPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Ded stopped by Self Serv User
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 18 |
LAST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Action
C=System
D=Hire Process
J=Job Data
O=Online User
S=Supplier Deduction File
W=Employee Self Service User
|
| 19 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 20 |
PROCESS_DEDN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Deduction
Y/N Table Edit
Default Value: Y
|
| 21 |
GVT_DED_DIST_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Deduction Distribution Code
|
| 22 |
GVT_PYMNT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Method
C=Check
E=Electronic Funds Transfer
N=None
Default Value: E
|
| 23 |
GVT_CHK_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
GVT Check Payee Name
|
| 24 |
GVT_ADDRESS1 |
Character(35) |
VARCHAR2(35) NOT NULL |
GVT Address Line 1
|
| 25 |
GVT_ADDRESS2 |
Character(35) |
VARCHAR2(35) NOT NULL |
GVT Address Line 2
|
| 26 |
GVT_ADDRESS_CITY |
Character(16) |
VARCHAR2(16) NOT NULL |
GVT Address City
|
| 27 |
GVT_ADDRESS_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
GVT Address State
Prompt Table:
PY_FED_STATE_VW
|
| 28 |
GVT_ADDRESS_ZIP |
Character(10) |
VARCHAR2(10) NOT NULL |
GVT Address Zip
|
| 29 |
GVT_ADDRESS_CNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Address Country
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 30 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 31 |
ACCOUNT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
Account Number
|
| 32 |
ACCOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
|
| 33 |
GVT_PAYEE_ID_NO |
Character(9) |
VARCHAR2(9) NOT NULL |
GVT EFT Payee ID Number
|
| 34 |
GVT_PAYEE_NAME |
Character(22) |
VARCHAR2(22) NOT NULL |
GVT EFT Account Holder
|
| 35 |
GVT_ALLOT_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT Allotment Pushbutton
|