| # |
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:
SET_VLD_HR_05
|
| 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
Default Value: M
Prompt Table:
MTH_FREQ_TBL_VW
|
| 13 |
FREQ_ID_DAILY |
Character(5) |
VARCHAR2(5) NOT NULL |
Daily Frequency
Default Value: D
Prompt Table:
DAY_FREQ_TBL_VW
|
| 14 |
FREQ_ID_HOURLY |
Character(5) |
VARCHAR2(5) NOT NULL |
Hourly Frequency
Default Value: H
Prompt Table:
HOUR_FREQTBL_VW
|
| 15 |
AUTO_CALC_PREM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Calculated Premium
Y/N Table Edit
Default Value: N
|
| 16 |
CMP_RTCD_PREM_ABS |
Character(6) |
VARCHAR2(6) NOT NULL |
Absorbing Premium Rate Code
Prompt Table:
CMP_PREM_ABS_VW
|
| 17 |
CMP_RTCD_PREM_NONA |
Character(6) |
VARCHAR2(6) NOT NULL |
Non-Absorbing Premium Rate Code
Prompt Table:
CMP_PREM_NONA_V
|
| 18 |
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
|
| 19 |
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
|
| 20 |
GVT_NEXT_PAY_ADJ |
Date(10) |
DATE |
GVT Next Scheduled Pay Adjust
|
| 21 |
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
|
| 22 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tariff Area
Prompt Table:
TARIFF_AREA_GER
|
| 23 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 24 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 25 |
URL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table:
PSURLDEFN
|
| 26 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 27 |
ADDED_BY |
Character(50) |
VARCHAR2(50) NOT NULL |
Added By
|
| 28 |
ADDED_DT |
Date(10) |
DATE |
Date Added
|
| 29 |
WAGE_PROG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Wage Progression Plan
Y/N Table Edit
Default Value: N
|