SPM Default Lookups

The SPM Schema contains RT_LOOKUP sets that are necessary for core functions of SPM. These are automatically created during the SPM Schema update, as explained in Update Database Schema.

SPM Durations

SPM durations are used to setup task duration in SPM. This list cannot be changed.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_DURATION	d	Day(s)
SPM_DURATION	h	Hour(s)
SPM_DURATION	m	Month(s)
SPM_DURATION	w	Week(s)

EDGE Activities

The EDGE Activities list is used in the activity manager form to define a field type in EDGE. This list cannot be changed.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
ACTIVITY_FIELD_TYPE	EDGE_DECIMAL	EDGE_DECIMAL
ACTIVITY_FIELD_TYPE	EDGE_INTEGER	EDGE_INTEGER
ACTIVITY_FIELD_TYPE	EDGE_TEXT	EDGE_TEXT

SPM Reschedule Action

SPM Reschedule Action is needed for SPM Rescheduling under custom dates. This list cannot be changed.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_DATE_RESCHEDULE_ACTION	b	Backward
SPM_DATE_RESCHEDULE_ACTION	c	Closest
SPM_DATE_RESCHEDULE_ACTION	f	Forward
SPM_DATE_RESCHEDULE_ACTION	n	None

SPM Task State

The SPM Task State list can be edited, as long as the same LOOKUP_TYPE is used.

Note: SPM is designed to allow only tasks with a task status code starting with “A_” to be scheduled.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_PLANNED_TASK_STATE	A_APPROVED	Approved
SPM_PLANNED_TASK_STATE	R_REVIEW	Needs Review
SPM_PLANNED_TASK_STATE	X_REJECTED	Rejected

SPM Task Priority

The SPM Task Priority list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_RANKING_PRIORITY	1	High
SPM_RANKING_PRIORITY	2	Normal
SPM_RANKING_PRIORITY	3	Low

SPM Land Access

The SPM Land Access list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_LA_STATUS	a_	Accepted
SPM_LA_STATUS	c_	Canceled
SPM_LA_STATUS	m_	Modified
SPM_LA_STATUS	r_	Rejected

SRN Resample Request Type

The SRN Resample list decides what kinds of resample requests are available in drop-down menus in the SRN Manager > Edit WO > Resample Requests > Add button. This can be edited and added to, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_RESAMPLE	amendment	amendment
SPM_RESAMPLE	resample	resample
SPM_RESAMPLE	retest	retest

SRN Resample Request Reason

The SRN Resample Reason list decides what reasons appear in drop-down menus in the SRN Manager > Edit WO > Resample Requests >Reason Code field. This can be edited and added to, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
RESAMPLE_REASON	resample_reason1	resample_reason1
RESAMPLE_REASON	resample_reason2	resample_reason2
RESAMPLE_REASON	resample_reason3	resample_reason3
RESAMPLE_REASON	srn	srn

SRN Amendment Reasons

The SRN Amendment Reasons list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SRN_AMENDMENT	amendment1	amendment1
SRN_AMENDMENT	amendment2	amendment2
SRN_AMENDMENT	amendment3	amendment3

SRN General Issues

The SRN General Issues list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SRN_ISSUE	issue1	issue1
SRN_ISSUE	issue2	issue2
SRN_ISSUE	issue3	issue3

SRN Sample Issues

The SRN Sample Issues list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SRN_ISSUE_SAMPLE	issue_sample1	issue_sample1
SRN_ISSUE_SAMPLE	issue_sample2	issue_sample2
SRN_ISSUE_SAMPLE	issue_sample3	issue_sample3

SPM Commitment Documents

The SPM Commitment Documents list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_COMMITMENT_REPORT	report1	report description

SPM Commitment Monitor Program

The SPM Commitment Monitor Program list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
MONITOR_PROGRAM_LOOKUP	MonitorProgram	Monitoring program

SPM Commitment Monitor Program Type

The SPM Commitment Monitor Program Type list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
MONITOR_TYPE_LOOKUP	MonitorType	Monitoring Type

SPM Commitment Authority

SPM Commitment Authority list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
AUTHORITY_LOOKUP	authority	Authority

SPM Commitment Authority Type

SPM Commitment Authority Type list can be edited, as long as the same LOOKUP_TYPE is used.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
AUTHORITY_LOOKUP_TYPE	authority_type	Authority Type

SPM FLD_QUALIFIER

The SPM FLD_QUALIFIER is needed for SPM KPI reports. This list cannot be removed, but it can be expanded.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
FLD_QUALIFIER	not_completed	Not completed
FLD_QUALIFIER	not_on_time	Not completed on time

SPM Report Level

The SPM FLD_QUALIFIER is needed for the Advanced Cost Manager. This list cannot be changed.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_RL	1	Level 1
SPM_RL	2	Level 2
SPM_RL	3	Level 3

SPM Turn Around Time (TAT)

The SPM Turn Around Time list is needed for the Advanced Cost Manager. Records in this list should not be deleted or edited to avoid unwanted behavior. However, new options can be added via new entries in the RT_LOOKUP table with a LOOKUP_TYPE of SPM_TAT.

LOOKUP_TYPE	LOOKUP_CODE	LOOKUP_DESC
SPM_TAT	1	1 Day
SPM_TAT	2	2 Days
SPM_TAT	3	3 Days
SPM_TAT	7	7 Days
SPM_TAT	14	14 Days
SPM_TAT	21	21 Days
SPM_TAT	28	28 Days