Default Lookups

<< Click to Display Table of Contents >>

EQuIS 7  >>  SPM > SPM Desktop > Configuration >

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 set up 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_

Cancelled

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 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 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 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 Advanced Cost Manager. This list cannot be changed.

 

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