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 |
|
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* |
|
| ||||||||||||||||||||||||||||||
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* |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acct Category | ACACCTCAT |
Required
| ||||||||||||
Activity | ACACTIVITY |
Required
| ||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||
Dist Account | GLMASTER |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Paemployee | PAEMPLOYEE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Assignment | CWASSIGN |
| ||||||||||||||||||
Emp Contract | CWCONTRACT |
| ||||||||||||||||||
Emp Position | PAEMPPOS |
| ||||||||||||||||||
Pay Code | PRPAYCODE |
|
All trademarks and registered trademarks are the property of their
respective owners.