| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 2 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
Default Value: OPR_DEF_TBL_HR.STD_HRS_DEFAULT
|
| 8 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
Default Value: OPR_DEF_TBL_HR.STD_HRS_FREQUENCY
Prompt Table:
STDHRS_FREQ_VW
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 10 |
SALARY_MATRIX_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Matrix Code
Prompt Table:
SAL_MATRIX_TBL
|
| 11 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 12 |
FREQ_ID_MONTHLY |
Character(5) |
VARCHAR2(5) NOT NULL |
Monthly Frequency
Prompt Table:
MTH_FREQ_TBL_VW
|
| 13 |
FREQ_ID_DAILY |
Character(5) |
VARCHAR2(5) NOT NULL |
Daily Frequency
Prompt Table:
DAY_FREQ_TBL_VW
|
| 14 |
FREQ_ID_HOURLY |
Character(5) |
VARCHAR2(5) NOT NULL |
Hourly Frequency
Prompt Table:
HOUR_FREQTBL_VW
|
| 15 |
GVT_SAL_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Salary Basis
A=Annual Basis
B=Biweekly Basis
H=Hourly Basis
M=Monthly Basis
Default Value: A
|
| 16 |
GVT_GEOG_SCOPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Geographic Scope of Plan
L=Local Special Rate
N=Nationwide Special Rate
W=Worldwide Special Rate
X=Regular Rate
Default Value: L
|
| 17 |
GVT_NEXT_PAY_ADJ |
Date(10) |
DATE |
GVT Next Scheduled Pay Adjust
|
| 18 |
TARIFF_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Tariff
01=Metal Processing
02=Banking
03=Building and Civil Engineering
04=Clothing Industry
05=Chemical Industry
06=Printing Industry
07=Retail Trade
08=Fossil Oil and Gas Extraction
09=Glass Industry
10=Wholesale and Foreign Trade
11=Wood Processing
12=Rubber Processing
13=Ceramics
14=Agriculture
15=Leather Processing
16=Public Sector
17=Paper Industry
18=Paper Processing
19=Sawing Industry
20=German Seaports
21=Hard-Coal Mining
22=Textile Industry
23=Insurance
24=Housing Industry
25=Periodical Publishers
26=Newspaper Publishers
27=Tobacco Industry
|
| 19 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tariff Area
Prompt Table:
TARIFF_AREA_GER
|
| 20 |
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
|
| 21 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|