|
|
TAPLAN FILE
REFERENCED BY
BN15.1 BN215 HR11.1 HR511 PA100 PA52.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAP-COMPANY Numeric 4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
TAP-PLAN Alpha 10
Element: Ta Plan
TAP-DESCRIPTION Alpha 30 (Lower Case)
Element: Ta DescriptionThis field displays the description.
TAP-STATUS Numeric 1
Element: Ta Status This field displays the status of the
transaction.
1 = Active
2 = Inactive
TAP-AUTO-ENROLL Numeric 1
Element: Ta Auto Enroll0 = No
1 = Yes
TAP-BALANCE-TYPE Numeric 1
Element: Ta Balance 1 = Employee group
2 = Position code
TAP-ENROLL-TYPE Numeric 1
Element: Ta Enroll Type1 = Employee Group
2 = Employee group; position code
3 = Employee group; position level
TAP-TABLE-BASIS Numeric 1
Element: Ta Basis 1 = Cycle based
2 = Hours based
TAP-CATEGORY Alpha 10
Element: Ta Category A category code is user-defined and
represents a general ledger account for
a specific type of expense type during
expense entry.
TAP-WEB-AVAILABLE Alpha 1
Element: Web Available 1 = Not Available
2 = Available
TAP-WEB-AVAIL-SUPV Alpha 1
Element: Web Avail Supv1 = Not Available
2 = Available
TAP-DATE-STAMP Numeric 8 (yyyymmdd)
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TAP-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TAP-USER-ID Alpha 10 (Lower Case)
Element: User Contains the user ID of the person who
last changed this record.
TAPLAN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TAPSET1 COMPANY BN15.1 BN215
PLAN HR11.1 HR511
PA100 PA52.4
TAPSET2 COMPANY Subset
PLAN Where (WEB-AVAILABLE = "2" )
TAPSET3 COMPANY Subset
PLAN Where (WEB-AVAIL-SUPV = "2" )
TAPSET4 COMPANY Subset HR11.1 HR511
PLAN Where (STATUS = 1 ) PA100 PA52.4
TAPLAN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Category PCODES Not Required
"TC" -> PCO-TYPE
TAP-CATEGORY -> PCO-CODE
Company PRSYSTEM Required
TAP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
TAPLAN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employees TAEEMASTER
TAP-COMPANY -> TEM-COMPANY
TAP-PLAN -> TEM-PLAN
TEM-EMPLOYEE-GROUP
TEM-EMPLOYEE
TEM-POSITION
Structure TASTRUCTUR
TAP-COMPANY -> TST-COMPANY
TAP-PLAN -> TST-PLAN
TST-EMPLOYEE-GROUP
TST-BEGIN-DATE
|
