| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
COMP_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Computation Period
A=All Periods
H=Hire Period
T=Termination Period
Default Value: A
|
| 3 |
HRS_CNV_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Conversion Rule Type
R=Ratio
S=Schedule
U=User Code
Z=Zero or One
Default Value: Z
|
| 4 |
HOURS_DIV_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Divisor Field Type
N=Numeric Constant
V=Variable by Employee
Default Value: N
|
| 5 |
HOURS_DIVISOR |
Number(4,0) |
SMALLINT NOT NULL |
Hours Divisor
|
| 6 |
HRS_DIV_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Hours Divisor Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 7 |
HRS_DIV_ALS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Hours Divisor Alias Type
|
| 8 |
DECIMAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Decimal Places Field Type
N=Numeric Constant
V=Variable by Employee
Default Value: N
|
| 9 |
DECIMAL_PLACES |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Places
|
| 10 |
DEC_PLC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Decimal places alias name
Prompt Table:
PA_ALIAS_USE
|
| 11 |
DEC_PLC_ALS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Decimal places alias type
|
| 12 |
MIN_ACCRUAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Hours Accrual Type
N=Numeric Constant
V=Variable by Employee
Default Value: N
|
| 13 |
MINIMUM_ACCRUAL |
Number(4,0) |
SMALLINT NOT NULL |
Minimum Hours for Accrual
|
| 14 |
MIN_ACCR_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum accrual alias name
Prompt Table:
PA_ALIAS_USE
|
| 15 |
MIN_ACCR_ALS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Minimum accrual alias type
|
| 16 |
MIN_SVC_UNIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Hours for Svc Unit
N=Numeric Constant
V=Variable by Employee
Default Value: N
|
| 17 |
MINIMUM_SVC_UNIT |
Number(5,0) |
INTEGER NOT NULL |
Minimum Hours for One
|
| 18 |
MIN_SVC_UN_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Min Svc Unit alias name
Prompt Table:
PA_ALIAS_USE
|
| 19 |
MIN_SVC_UN_ALS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Min svc unit alias type
|
| 20 |
ZERO_ONE_RULE |
Number(4,0) |
SMALLINT NOT NULL |
Hours Needed for One Svc Unit
|
| 21 |
SCHEDULE_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule Name
Prompt Table:
PA_SVC_SCHEDS
|
| 22 |
ET_HRS_CNV_DU_OPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Elap Time Hrs Cnv Duration Opt
Prompt Table:
PA_DURATION_OPT
|