Table Information for the Manage Opportunities Screen

Changes to the Manage Opportunities screen update several tables.

Updated tables include:

  • CT_ACTIVITIES
  • CT_GENL_UDEF
  • CT_DOCUMENTS
  • CTM_LAB_CAT
  • CTM_LC_CRITERIA
  • CTM_LC_RESOURCE
  • OPP_ASSESSMENT
  • OPP_EMPL_TEAM
  • OPP_GOVWINIQ
  • OPP_GWIQ_ADDED_BY
  • OPP_GWIQ_CONTACTS
  • OPP_GWIQ_KEY_DATES
  • OPP_MASTER
  • OPP_SUBC_PLAN
  • OPP_TEAMMATES
  • OPP_TEAMMATES_EMPL
  • OPP_VALUE_AUDIT
  • POST_AWARD_DEBRIEF
  • PROJ: This table is updated if you use the Project Initialization subtask.
  • PROJ_BILL_INFO: This table is updated if you use the Project Initialization subtask and select the Project Billing Info table in the Include list box.
  • PROJ_HIERARCHY: This table is updated if you use the Project Initialization subtask. It is derived from the PROJ table when the Include Basic Info check box is selected. This table stores all the projects and their parent project numbers.
  • PROJ_SRCE_PROJ: This table is updated if you use the Project Initialization subtask. It is derived from the PROJ table when the Include Basic Info check box is selected. This table stores all the projects and their source project numbers. The source project number is used for project labor category defaults and validations. If you select the Define Rate Sequence table in the Include list box, the PROJ_SRCE_PROJ table is re-evaluated and the appropriate source project number is updated based upon the selection in the T+M Rate Sequence Search for PLC Source Project group box on the Configure Project Settings screen and the TM_RT_ORDER table (Manage Rate Sequence Orders screen).
  • PROJ_INVC_PROJ: This table is updated if you use the Project Initialization subtask. It is derived from the PROJ_BILL_INFO table (determines the invoice project number) and the PROJ table (determines the child project numbers) when the Project Billing Info table is selected in the Include list box. This table stores the billing level invoice project number and all children of the invoice project.
  • PROJ_REV_PROJ: This table is updated if you use the Project Initialization subtask. It is derived from the PROJ_REV_SETUP table (determines the revenue project number) and the PROJ table (determines the child project numbers) when the Project Revenue Setup table is selected in the Include list box. This table stores the revenue level project number and all children of the revenue project.