INSTALL_PGM(SQL Table) |
Index Back |
|---|---|
System Options - PS/PGMInstallation options for Program Management. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PPK_INSTALLED | Character(1) | VARCHAR2(1) NOT NULL |
Project Porfolio Mgt Installed
Y/N Table Edit Default Value: N |
| 2 | EMAIL_APPROVED | Character(1) | VARCHAR2(1) NOT NULL |
Send E-Mail when Approved
Y/N Table Edit Default Value: N |
| 3 | EMAIL_CREATED | Character(1) | VARCHAR2(1) NOT NULL |
Send E-Mail when Created
Y/N Table Edit Default Value: N |
| 4 | EMAIL_DENIED | Character(1) | VARCHAR2(1) NOT NULL |
Send E-Mail when Denied
Y/N Table Edit Default Value: N |
| 5 | EMAIL_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |
Send E-Mail on Detail Created
Y/N Table Edit Default Value: N |
| 6 | EMAIL_UPDATED | Character(1) | VARCHAR2(1) NOT NULL |
Send E-Mail when Updated
Y/N Table Edit Default Value: N |
| 7 | FUND_MGR_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Require Funding Dept Mgr Appr
Y/N Table Edit Default Value: N |
| 8 | WF_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enable Workflow
Y/N Table Edit Default Value: N |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 11 | WF_ENABLED_ISSUE | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 12 | WF_ISSUE_SUMMARY | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Summary changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 13 | WF_ISSUE_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Priority changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 14 | WF_ISSUE_RESOLUTN | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Resolution Description changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 15 | WF_ISSUE_NOTES | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Notes changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 16 | WF_ISSUE_DESCR | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Description changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 17 | WF_ISSUE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Status changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 18 | WF_ISSUE_ACT_RESLN | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Actual Resolution Date changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 19 | WF_ISSUE_ATTACH | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Issue Attachment changes within Issue Management.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 20 | WF_ENABLED_ARL | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Activity Resource List
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 21 | WF_ACT_RES_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Activity Resource Name changes within the Activity Resource List.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 22 | WF_ENABLED_DELIV | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Deliverables.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 23 | WF_DELIV_ASSIGNED | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether workflow is enabled for Deliverable Assignment changes.
N=Disabled Y=Enabled Y/N Table Edit Default Value: N |
| 24 | WF_ENABLED_PGM_BUD | Character(1) | VARCHAR2(1) NOT NULL |
Program Management Budgeting Approval Workflow Enabled switch.
Y/N Table Edit Default Value: N |
| 25 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 26 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 27 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 28 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |