| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
CATEGORY |
Character(10) |
VARCHAR2(10) NOT NULL |
Category Name
Prompt Table:
PA_HR_ACT
|
| 3 |
SVC_DFN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
For future use
B=Break Definition
S=Service Definition Type
|
| 4 |
RECORD_IMPACTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Impacted
A=All
F=First Only
L=Last Only
N=No Records Impacted
X=All But First
Y=All But Last
Z=All But First and Last
|
| 5 |
ADJUSTMENT_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Rule
P=Periods to Add
U=User Code
|
| 6 |
PERIODS_ADD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Periods to Add Field Type
N=Numeric Constant
V=Variable by employee
|
| 7 |
PERIODS_TO_ADD |
Number(3,0) |
SMALLINT NOT NULL |
Periods to Add
|
| 8 |
PRDS_TO_ADD_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Periods to add alias name
Prompt Table:
PA_ALIAS_USE
|
| 9 |
PRDS_TO_AD_ALS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Periods to add alias type
|
| 10 |
PERIOD_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of the Period
D=Days
M=Months
W=Weeks
Y=Years
|
| 11 |
DT_RND_OPT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Date Round Option Name
Prompt Table:
PA_DATE_RND_OPT
|
| 12 |
MIN_MAX_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Min/Max Indicator
M=Minimum
N=No Limit
X=Maximum
|
| 13 |
MIN_MAX_HOURS |
Number(4,0) |
SMALLINT NOT NULL |
Min/Max Hours
|
| 14 |
LIMIT_PERIOD_HOURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Limitation Period
C=Computation Period
S=Status Period
Default Value: C
|
| 15 |
ALLOCATION_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Period
C=Cut Off at Limit
D=Spread Across Days
Default Value: D
|
| 16 |
LIMITATION_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Limitation Period
S=Status Period
U=User Code
Default Value: S
|
| 17 |
MIN_MAX_SERVICE |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Minimum or Maximum Svc Amount
|
| 18 |
ADD_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Add Time To Date?
Y/N Table Edit
|
| 19 |
MIN_MAX_HRS_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Min/Max Hours Adjust?
Y/N Table Edit
|
| 20 |
FUTURE_ADJ_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Future Adjustment Flag
A=Add Time to Current Act/Rsn
C=Ignore Current Action/Reason
F=Ignore Future Action/Reason
I=Insert Action/Reason
|
| 21 |
HIRE_CATG_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hire/Rehire Category Indicator
Y/N Table Edit
Default Value: N
|
| 22 |
CATG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Category Type
H=Hire Category
O=Other
T=Termination Category
|
| 23 |
INCLUDE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Include Code
Y/N Table Edit
|