INSTALL_PPK_VW(SQL View) |
Index Back |
|---|
| SELECT PPK_INSTALLED , EMAIL_APPROVED , EMAIL_CREATED , EMAIL_DENIED , EMAIL_DETAIL , EMAIL_UPDATED , FUND_MGR_APPR , WF_ENABLED , CURRENCY_CD , RT_TYPE , FMS_DTTM_STAMP , FMS_OPRID , FMS_LASTUPDDTTM , FMS_LASTUPDOPRID FROM %Table(INSTALL_PGM) |
| # | 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 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 12 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 13 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 14 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |