ACSUBCONT FILE
The Subcontract Employee file stores general information about subcontract
employees. Subcontracted employees can be attached to an Assignment instead
of an HR employee.
REFERENCED BY
AC209
UPDATED BY
AC09.1 AC560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SUB-SUBCONT-EMP Numeric 9 AC09.1 AC560
Subcont Emp The ID for the subcontract employee.
SUB-DESCRIPTION Alpha 30 (Lower Case) AC09.1 AC560
Description Concatenation of part of last name, part
of first name and middle initial.
SUB-FICA-NBR Alpha 15 AC09.1 AC560
Social Security The subcontractor's social security
Number number.
SUB-LAST-NAME Alpha 30 (Lower Case) AC09.1 AC560
Last Name The subcontractor's last name.
SUB-FIRST-NAME Alpha 15 (Lower Case) AC09.1 AC560
First Name The subcontractor's first name.
SUB-MIDDLE-INIT Alpha 1 AC09.1 AC560
Middle Initial The subcontractor's middle initial.
SUB-TITLE Alpha 30 (Lower Case) AC09.1 AC560
Title The subcontractor's title.
SUB-PHONE-COUNTRY Alpha 6 AC09.1 AC560
Telephone Country The subcontractor's telephone country
Code code.
SUB-PHONE Alpha 15 AC09.1 AC560
Telephone Number The subcontractor's complete telephone
number (including the area code).
SUB-PHONE-EXT Alpha 5 AC09.1 AC560
Telephone Extension The subcontractor's telephone extension
number.
SUB-E-MAIL-ADDR Alpha 60 AC09.1 AC560
E Mail Addr The subcontractor's E-mail address.
SUB-AP-COMPANY Numeric 4 AC09.1 AC560
Ap Company The Accounts Payable company associated
with the subcontractor (the
subcontractor being processed as a
vendor).
SUB-VENDOR Alpha 9 (Right Justified) AC09.1 AC560
Vendor ID The subcontractor's vendor ID.
SUB-PAY-FREQUENCY Numeric 1 AC09.1 AC560
Pay Frequency 1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
ACSUBCONT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SUBSET1 SUBCONT-EMP This index retrieves subcontractor AC09.1 AC209
information by employee ID. AC560
SUBSET2 AP-COMPANY This index retrieves subcontractor AC209
VENDOR information by AP company and vendor ID.
SUBCONT-EMP KeyChange, Duplicates
ACSUBCONT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
SUB-AP-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
SUB-VENDOR -> VEN-VENDOR
ACSUBCONT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Abassign ABASSIGN
"S" -> ASN-EMPLOYEE-TYPE
SUB-SUBCONT-EMP -> ASN-EMPLOYEE
ASN-ASSIGNMENT
|
