01 vAPI_add_edit_employee

Add/edit an employee master record

Inputs:

Input Name	Required	Type	Max Length	Details
$arg_array	YES	ASSOC	--	Details follow:
$arg_array / company_id	YES	INT	--	references: company_master.company_id
				Company ID of current login context
$arg_array / employee_id	YES	INT	--	references: employee_master.employee_id
				Employee ID of the person Adding/Editing this record
$arg_array / employee_code	YES	STRING	16	references: employee_master.employee_code
$arg_array / default_company	YES	INT		references: employee_master.default_company
$arg_array / password	YES	STRING	10	references: employee_master.password
$arg_array / first_name	NO	STRING	64	references: employee_master.first_name
$arg_array / middle_name	NO	STRING	64	references: employee_master.middle_name
$arg_array / last_name	NO	STRING	64	references: employee_master.last_name
$arg_array / position	NO	STRING	64	references: employee_master.position
$arg_array / company_location	NO	STRING	32	references: employee_master.company_location
$arg_array / office_phone	NO	STRING	64	references: employee_master.office_phone
$arg_array / office_fax	NO	STRING	64	references: employee_master.office_fax
$arg_array / work_mobile_phone	NO	STRING	64	references: employee_master.work_mobile_phone
$arg_array / pager	NO	STRING	64	references: employee_master.pager
$arg_array / date_hired	YES	DATE	--	references: employee_master.date_hired
				format: YYYY-MM-DD
$arg_array / termination_date	NO	DATE	--	references: employee_master.termination_date
				format: YYYY-MM-DD
$arg_array / notes	NO	TEXT	--	references: employee_master.notes
$arg_array / home_phone	NO	STRING	32	references: employee_master.home_phone
$arg_array / personal_mobile_phone	NO	STRING	32	references: employee_master.personal_mobile_phone
$arg_array / email	NO	STRING	64	references: employee_master.email
$arg_array / home_address_1	NO	STRING	32	references: employee_master.home_address_1
$arg_array / home_address_2	NO	STRING	32	references: employee_master.home_address_2
$arg_array / home_address_3	NO	STRING	32	references: employee_master.home_address_3
$arg_array / home_city	NO	STRING	32	references: employee_master.home_city
$arg_array / home_locality	NO	STRING	32	references: employee_master.home_locality
$arg_array / home_mailing_code	NO	STRING	16	references: employee_master.home_mailing_code
$arg_array / emergency_contact	NO	STRING	64	references: employee_master.emergency_contact
$arg_array / warehouse_code	YES	STRING	8	references: employee_default_warehouse.warehouse_code
$arg_array / printer_code	NO	STRING	16	references: employee_default_printer.printer_code
$dbconn	YES	DBHANDLE	--	Database Connection

Outputs:

Output Name	Type	Details
$record	ASSOC	Details follow:
$record / action	STRING	ADD: New record was added
		EDIT: Existing record was updated

Error Codes:

PGQUERY	Failed SQL query
CHECKPOINT	Error when calling the checkpoint function

Called API Functions:
logAPI:vAPI_checkpoint_table_revision

Return to:
Employee_API Reference