Activities Interface Staging Table Structure

This table lists the details of the Activities 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	Conditional	You can bulk load projects and use the system autonumbering functionality to generate the next PROJECT_ID. In this case, PROJECT_IDs are not required. However, if you perform update projects or incrementally add activities to projects, then PROJECT_IDs are required and are validated against the PROJECT table.
5	ACTIVITY_ID	Character	Conditional	You can bulk load activities and use the system autonumbering functionality to generate the next ACTIVITY_ID. In this case, ACTIVITY_IDs are not required. However, if you perform updates or incrementally add activities to projects, then ACTIVITY_IDs are required and are validated against the PROJ_ACTIVITY table.
6	INTFC_TYPE	Character	Optional	Not used in the activity interface.
7	INTFC_STATUS	Character	Optional	Populate the field with NEW.
8	LOAD_STATUS	Character	Optional	Populate the field with NEW.
9	ORIG_INTFC_ID	Number	Optional	Not used in the activity interface.
10	ORIG_LINE_NUM	Number	Optional	Not used in the activity interface.
11	ACTIVITY_DESCR	Character	Optional	Activity description up to 30 characters.
12	ACTIVITY_TYPE	Character	Optional	Prompts from the PROJ_ACT_TBL table.
13	SYSTEM_SOURCE	Character	Optional	Populate the field with BPC (batch process).
14	PERCENT_COMPLETE	Number	Optional	Schedule status percent complete.
15	EARLY_START_DT	Date	Optional	Early start date.
16	LATE_START_DT	Date	Optional	Late start date.
17	ACTUAL_START_DT	Date	Optional	Actual start date.
18	EARLY_FINISH_DT	Date	Optional	Early finish date.
19	LATE_FINISH_DT	Date	Optional	Late finish date.
20	ACTUAL_FINISH_DT	Date	Optional	Actual finish date.
21	BASELINE_FINISH_DT	Date	Optional	Baseline finish date.
22	BASELINE_START_DT	Date	Optional	Baseline start date.
23	BCWP	Number	Optional	Work performed.
24	BCWS	Number	Optional	Work scheduled.
25	ACT_TYPE_SCH	Character	Optional	Schedule activity type. Prompts from the PC_ACT_TYPE_SCH table.
26	DTTM_STAMP	Date/Time	System-maintained	Date and time when the project is created.
27	DRAWING_NAME	Character	Optional	Not used in the activity interface.
28	ACTIVITY_USER1	Character	Optional	User-defined field.
29	ACTIVITY_USER2	Character	Optional	User-defined field.
30	ACTIVITY_USER3	Character	Optional	User-defined field.
31	ACTIVITY_USER4	Character	Optional	User-defined field.
32	ACTIVITY_USER5	Character	Optional	User-defined field.
33	PC_ACT_USER_DT1	Date	Optional	User-defined field.
34	PC_ACT_USER_DT2	Date	Optional	User-defined field.
35	PC_USER_CURRENCY	Character	Optional	User-defined field. Prompts from the CURRENCY_CD_TBL table.
36	PC_ACT_USERAMT1	Sign	Optional	User-defined field.
37	PC_ACT_USERAMT2	Sign	Optional	User-defined field.
38	PC_ACT_USERAMT3	Sign	Optional	User-defined field.
39	SETID	Character	Required	Not used in the activity interface.
40	OPRID	Character	Optional	The interface assigns an operator ID.
41	PROCESS_INSTANCE	Number	System-maintained	The interface assigns a process instance number.
42	DESCR254	Character	Optional	Activity description up to 254 characters.
43	ACT_LOC_EFFDT	Date	Optional	Activity location effective date. Populated with %Date (current server date) if not provided in the source file.
44	EFFSEQ	Number	Optional	Activity location effective sequence or activity status effective sequence. Default value is 1.
45	LOCATION	Character	Optional	Must be a value from the LOCATION_TBL table. Default value is from LOCATION_TBL.LOCATION.
46	LOCATION_FRACTION	Number	Optional	Not used in the activity interface.
47	ACTIVITY_STATUS	Character	Optional	Activity status. Prompts from the PROJ_STATUS_TBL table.
48	ACT_STATUS_EFFDT	Date	Optional	Activity status effective date. Populated with %Date (current server date) if not provided in the source file.
49	START_DT_2	Date	Optional	User-defined field.
50	END_DT_2	Date	Optional	User-defined field.
51	START_DT	Date	Required	Activity start date.
52	END_DT	Date	Required	Activity end date.
53	ACTIVITY_PRIORITY	Number	Optional	Activity priority.
54	ACT_PCT_COMPLETE	Number	Optional	Activity percentage complete.
55	QUALITY_DTTM	Date/Time	System-maintained	Date and time when the record is created.
56	QUALITY_TYPE	Character	Optional	Prompts from the PROJ_QUAL_TBL table.
57	QUALITY_RATING	Number	Optional	Not used in the activity interface.
58	QUALITY_WEIGHT	Number	Optional	Not used in the activity interface.
59	QUALITY_MEMBER	Character	Optional	Prompts from the PROJ_TEAM_VW table.
60	ADDRESS_SBR	Subrecord	Optional	The interface assigns address information.
1 (ADDRESS_SBR)	COUNTRY	Character	Optional	Country. Prompts from the COUNTRY_TBL table.
2 (ADDRESS_SBR)	ADDRESS1	Character	Optional	Address line 1.
3 (ADDRESS_SBR)	ADDRESS2	Character	Optional	Address line 2.
4 (ADDRESS_SBR)	ADDRESS3	Character	Optional	Address line 3.
5 (ADDRESS_SBR)	ADDRESS4	Character	Optional	Address line 4.
6 (ADDRESS_SBR)	CITY	Character	Optional	City.
7 (ADDRESS_SBR)	NUM6	Character	Optional	Number 6.
8 (ADDRESS_SBR)	NUM2	Character	Optional	Number 2.
9 (ADDRESS_SBR)	HOUSE_TYPE	Character	Optional	House type. Prompts from the translate values for the HOUSE_TYPE field.
10 (ADDRESS_SBR)	ADDR_FIELD1	Character	Optional	Address field 1. Prompts from the translate values for the ADDR_FIELD1 field.
11 (ADDRESS_SBR)	ADDR_FIELD2	Character	Optional	Address field 2.
12 (ADDRESS_SBR)	ADDR_FIELD3	Character	Optional	Address field 3.
13 (ADDRESS_SBR)	COUNTY	Character	Optional	County.
14 (ADDRESS_SBR)	STATE	Character	Optional	State.
15 (ADDRESS_SBR)	POSTAL	Character	Optional	Postal code.
16 (ADDRESS_SBR)	GEO_CODE	Character	Optional	Tax vendor geographic.
17 (ADDRESS_SBR)	IN_CITY_LIMIT	Character	Optional	Within city limit (yes or no).
61	RATE_PLAN	Character	Optional	Not used in the PeopleSoft Project Costing interface. Note: The default value of the rate plan or rate set is based on the project type of the project or activity if you associate a predefined rate set or rate plan with the project type, and include the project type in the source file.
62	PC_MILESTONE_FLG	Character	Conditional	Indicates if activity is a milestone.
63	AFUDC_ACT_SW	Character	Conditional	Allows interest calculations for this project activity.
64	ACT_TEMPLATE_SW	Character		Not used in the PeopleSoft Project Costing interface.
65	PC_SCH_FIELD1	Character	Optional	Third-party user field.
66	PC_SCH_FIELD2	Character	Optional	Third-party user field.
67	PC_SCH_FIELD3	Character	Optional	Third-party user field.
68	PC_SCH_FIELD4	Character	Optional	Third-party user field.
69	PC_SCH_FIELD5	Character	Optional	Third-party user field.
70	PC_SCH_FIELD6	Character	Optional	Third-party user field.
71	PC_SCH_FIELD7	Character	Optional	Third-party user field.
72	SUMMARY_ACT	Character	Optional	Designates an activity as a summary activity. The default value is N (no).
73	PC_DURATION	Number		Duration.
74	ENFORCE	Character	Optional	Identifies the enforce project team option, such as PeopleSoft Expenses only, PeopleSoft Time and Labor only, Expenses and Time and Labor, or do not enforce.
75	PC_CHC_ACT_SW	Character	Optional	Enables change control. Default value is PROJECT.PC_CHC_SW.
76	PGM_SCHED_METHOD	Character	Optional	Schedule method, such as fixed units, duration, and work. Default value is PROJECT.PGM_SCHED_METHOD.
77	WBS_ID	Character	Optional	Coded hierarchy identifier for each activity.
78	PGM_WBS_SBR	Subrecord	Optional	Hierarchy grid subrecord.
1 (PGM_WBS_SBR) through 26 (PGM_WBS_SBR)	LEVEL1 through LEVEL 26	Number	Optional
79	LEVEL_NUM	Number	Optional
80	ROW_NUMBER_5	Number	Optional	Internal sequence number assigned to each row to uniquely identify a row.
81	DEADLINE_DT	Date	Optional	Deadline date.
82	CONSTRAINT_DT	Date	Optional	Constraint date.
83	CONSTRAINT_TYPE	Character	Optional	Constraint type.
84	COSTING_ACT_SW	Character	Optional	Activity costing flag. Indicates whether an activity is available for charging.
85	PC_ACT_OWNER	Character	Optional	Activity owner. Prompts from PC_TEAM_PROM_VW table.
86	CURRENCY_CD	Character	Optional	Default value is PROJECT.CURRENCY_CD.
87	PC_ACT_DEF_CALC_MT	Character	Optional	Activity calculation method. Default value is PROJECT.PC_ACT_DEF_CALC_MT.