Resources Interface Table Structure

This table lists the details of the Resources Interface staging table structure:

Field Number	Field Name	Type	Criteria	Description
1	INTFC_ID	Number	Required	Batch interface identifier.
2	INTFC_LINE_NUM	Number	Required	Unique batch line identifier.
3	BUSINESS_UNIT	Character	Required	Prompts from the SP_BU_PC_NONVW table.
4	PROJECT_ID	Character	Required	Unique project identifier
5	ACTIVITY_ID	Character	Optional	Required if loading activity team member. Otherwise, leave blank for project team member.
6	TEAM_MEMBER_CLASS	Character	Required	“L” for labor, “M” for material, “A” for equipment asset.
7	TEAM_MEMBER_IND	Character	Required	For named resources, use “E”. For generic resources, use “G” if labor resource, else use “N” for material or equipment asset generic resource.
8	TEAM_MEMBER	Character	Required	For named resources, this is the unique valid resource ID. For generic resources, this is a generic text field.
9	PLAN_STARTDT	Character	Optional	Required if adding project team member. Indicates the planned start date the resource is assigned to the project.
10	PLAN_ENDDT	Character	Optional	Required if adding project team member. Indicates the planned end date the resource is assigned to the project.
11	PROJ_ROLE	Character	Optional	Required for labor resource. Prompts from the PROJ_ROLE table.
12	BUSINESS_UNIT_AM	Character	Optional	Required for equipment asset resource. The Asset Management business unit associated with the resource.
13	ASSET_TYPE	Character	Optional	Required for equipment asset resource. The type of asset.
14	ASSET_SUBTYPE	Character	Optional	Required for equipment asset resource. Prompts from the AM_SUBTYPE table.
15	MODEL	Character	Optional	Optional for equipment asset resource. Prompts from the MFG_MODEL equipment asset.
16	MFG_ID	Character	Optional	Optional for equipment asset resource. Prompts from the MANUFACTURER table.
17	AVAIL_UNITS	Number	Optional	Not used if loading project team member. For activity team member: If labor resource, this is the percentage of time the resource is allocated on the activity. If non-labor resource, this is the quantity of the resource in terms of unit of measure.
18	UNIT_OF_MEASURE	Character	Optional	Not used if loading project team member. For activity team member, this is the unit of measure associated with the quantity, cost, and bill rates. Prompts from the UNITS_TBL table.
19	PGM_RATE_TYPE	Character	Optional	Indicates the source of the cost rate. “C” is for customer rate. “J” is for job code rate (for labor only. “E” is for employee rate (for labor only). “R” is for role rate (for labor only).
20	COST_RATE	Number	Optional	The cost rate for the resource.
21	CURRENCY_CD	Character	Optional	The currency code associated with the cost rate. Prompts for the CURRENCY_CD_TBL table.
22	BILL_RATE	Number	Optional	The bill rate for the resource.
23	BILL_RATE_TYPE_1	Character	Optional	Indicates the source of the billing rate. “C” is for customer rate. “J” is for jobcode rate (for labor only). “E” is for employee rate (for labor only). “R” is for role rate (for labor only).
24	BILL_CURRENCY_CD	Character	Optional	The currency code associated with the billing rate. Prompts for the CURRENCY_CD_TBL table.
25	ASSGND_WORK	Number	Optional	For labor resources only. Not used if loading project team member. For activity team member, this is the number of days, or hours, to which the resource is assigned. The units will be based on the unit of measure field.
26	BASELINE_WORK	Number	Optional	For labor resources only. For information only. Not used if loading project team member. For activity team member, this is the baseline (original) number of days, or hours, to which the resource is assigned. The units will be based on the unit of measure field.
27	INTFC_STATUS	Character	Optional	Set to “NEW” for loading. This will get updated to “DON” if loaded successfully, or “ERR” if an error is encountered.
28	LOAD_STATUS	Character	Optional	Populated in the Application Engine with NEW if not provided in the source file.
29	SOURCE_FLAG			The source where the team was created: G – Proposal Management. M – Microsoft Projects. P – Project Costing. R – Resource Management.
30	ERR_REASON			Can be left blank for loading. If an error is encountered during the load, this field is populated with the reason code.
31	PC_DURATION			Can be left blank for loading.