|
|
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SUB-SUBCONT-EMP Numeric 9
Element: Subcont Emp The ID for the subcontract employee.
SUB-DESCRIPTION Alpha 30 (Lower Case)
Element: Description Concatenation of part of last name, part
of first name and middle initial.
SUB-FICA-NBR Alpha 15
Social Security The subcontractor's social security
Number number.
SUB-LAST-NAME Alpha 30 (Lower Case)
Element: Name The subcontractor's last name.
SUB-FIRST-NAME Alpha 15 (Lower Case)
Element: First Name The subcontractor's first name.
SUB-MIDDLE-INIT Alpha 1
Element: Ac Usage The subcontractor's middle initial.
SUB-TITLE Alpha 30 (Lower Case)
Element: Title The subcontractor's title.
SUB-PHONE-COUNTRY Alpha 6
Telephone Country The subcontractor's telephone country
Code code.
SUB-PHONE Alpha 15
Element: Telephone NumbThe subcontractor's complete telephone
number (including the area code).
SUB-PHONE-EXT Alpha 5
Element: Telephone ExteThe subcontractor's telephone extension
number.
SUB-E-MAIL-ADDR Alpha 60
Element: E Mail Addr The subcontractor's E-mail address.
SUB-AP-COMPANY Numeric 4
Element: Ap Company The Accounts Payable company associated
with the subcontractor (the
subcontractor being processed as a
vendor).
SUB-VENDOR Alpha 9 (Right Justified)
Element: Vendor ID The subcontractor's vendor ID.
SUB-PAY-FREQUENCY Numeric 1
Element: 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 AC209
information by employee ID.
SUBSET2 AP-COMPANY This index retrieves subcontractor AC209
VENDOR information by AP company and vendor ID.
SUBCONT-EMP KeyChangeDuplicates
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
|
