BUSINESS_UNITDefault Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: %EDITTABLE
B=Budget
E=ETC
P=Project
PGM_ED_CHG_REQS(SQL View) |
Index Back |
|---|---|
Change Request Hdr ViewView of main change request info for sending to Endeca. |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.CHANGE_REQ_TYPE , A.CHANGE_REQ_ID %Concat '::' %Concat A.PRJ_CHNG_DESCR , A.CHANGE_EXPLANATION , A.BUSINESS_IMPACT , A.FMS_LASTUPDDTTM FROM PS_PGM_CHC_REQ_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDITTABLE |
| 3 | CHANGE_REQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Change Request Type
B=Budget E=ETC P=Project |
| 4 | CONCAT_PHYS_KEYS | Character(120) | VARCHAR2(120) NOT NULL | Concatinated physical_inv keys |
| 5 | CHANGE_EXPLANATION | Character(254) | VARCHAR2(254) NOT NULL | Change Explanation |
| 6 | BUSINESS_IMPACT | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 7 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |