CWDISTRIB

This file contains Employee Contract Base and Supplemental Assignment general ledger expense and activity account override information defined on the employee contract record. The CW130 Time Record Generation program will create time records based on the percent defined for these distribution accounts.
UPDATED BY
BN305 HR11.1 HR11.2 HR511 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CWD-COMPANY
Element: Company Hr
Numeric 4
Identifies the HR Company.
CWD-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
CWD-CONTRACT-YEAR
Element: Cw Contract Yr
Numeric 4
Identifies the Contract Year. A Contract is only allowed to be defined if a Contract Rule exists for that specific Contract Year.
CWD-POSITION
Element: Position
Alpha 12
Identifies the employee contract assignment by position. There is one to one relation from an employee position to the contract base assignment.
CWD-CONT-SEQ-NBR
Element: Cw Cont Seq No
Numeric 12
Identifies the employee's contract assignment segment record. There is a one to many relation from contract to segments.
CWD-PAY-CODE
Element: Pay Code
Alpha 4
The Pay Code associated with employee base assignment or supplemental assignment segment used for payouts is stored in this field.
CWD-GL-EFFECT-DATE
Element: Cw Effect Date
Numeric 8 (yyyymmdd)
The effective start date of the distribution record for the contract base assignment or supplemental assignment record.
CWD-GL-SEQ-NBR
Element: Cw Gl Seq Nbr
Numeric 4
A specific Dist Seq Nbr is assigned for a record that has the General Ledger or Activity Accounts overridden.
CWD-PCD-SEQ-NBR
Element: Pcd Seq Nbr
Numeric 4
The Pay Code's seq nbr associated to the contract's base or supplemental assignment record.
CWD-DIST-COMPANY
Element: Company
Numeric 4
Contains the company number to which a transaction is posted. A valid intercompany relationship must be defined in the General Ledger application
CWD-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the General Ledger Accounting Unit to which the application posts the wages expense amount.
CWD-DST-ACCOUNT
Element: Account
Numeric 6
Contains the General Ledger Account to which the application posts the wages expense amount.
CWD-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the General Ledger Sub Account to which the application posts the wages expense amount.
CWD-ACTIVITY
Element: Activity
Alpha 15
Contains the General Ledger Sub Account to which the application posts the wages expense amount.
CWD-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account Categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Activity Management.
CWD-PERCENT
Element: Percent
Signed 7.3
Contains the distribution percent.
CWD-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
CWD-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
CWD-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the person that last changed this record.
CWD-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This is the date that this record was added to the table.
CWD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
CWD-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the person that last changed this record.
CWD-FTE
Element: Fte
Signed 11.6
Allow distributions by FTE


CWDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CWDSET1 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
CONT-SEQ-NBR*
PAY-CODE
GL-EFFECT-DATE*
GL-SEQ-NBR*
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
CWDSET2 COMPANY
EMPLOYEE
CONTRACT-YEAR
POSITION
CONT-SEQ-NBR
PAY-CODE
GL-EFFECT-DATE
GL-SEQ-NBR
CWDSET3 COMPANY
CONTRACT-YEAR*
EMPLOYEE
POSITION
CONT-SEQ-NBR*
PAY-CODE
GL-EFFECT-DATE*
GL-SEQ-NBR*


CWDISTRIB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When (CWD-ACCT-CATEGORY !=Spaces )
CWD-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When (CWD-ACTIVITY !=Spaces )
CWD-ACTIVITY->ACV-ACTIVITY
Company PRSYSTEM Required
CWD-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Dist Account GLMASTER Required
CWD-COMPANY->GLM-COMPANY
CWD-DST-ACCT-UNIT->GLM-ACCT-UNIT
CWD-DST-ACCOUNT->GLM-ACCOUNT
CWD-DST-SUB-ACCT->GLM-SUB-ACCOUNT
Employee EMPLOYEE Required
CWD-COMPANY->EMP-COMPANY
CWD-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
CWD-COMPANY->PEM-COMPANY
CWD-EMPLOYEE->PEM-EMPLOYEE


CWDISTRIB FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Assignment CWASSIGN
CWD-COMPANY->CWA-COMPANY
CWD-CONTRACT-YEAR->CWA-CONTRACT-YEAR
CWD-EMPLOYEE->CWA-EMPLOYEE
CWD-POSITION->CWA-POSITION
  CWA-ASG-EFFECT-DTE
  CWA-PCD-SEQ-NBR
Emp Contract CWCONTRACT
CWD-COMPANY->CCT-COMPANY
CWD-EMPLOYEE->CCT-EMPLOYEE
CWD-CONTRACT-YEAR->CCT-CONTRACT-YEAR
CWD-POSITION->CCT-POSITION
  CCT-CONT-SEQ-NBR
Emp Position PAEMPPOS
CWD-COMPANY->PEP-COMPANY
CWD-EMPLOYEE->PEP-EMPLOYEE
CWD-POSITION->PEP-POSITION
  PEP-EFFECT-DATE
  PEP-POS-LEVEL
Pay Code PRPAYCODE
CWD-COMPANY->PCD-COMPANY
CWD-PAY-CODE->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE


File created: Wed Jun 08 20:48:31 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.