BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: SP_PROJ_NONVW
CONCAT_PHYS_KEYSPGM_ED_RSK_NOTE(SQL View) |
Index Back |
|---|---|
Risk Management NotesView of Risk Notes for sending to Endeca |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.RISK_ID %Concat '::' %Concat %NumToChar(A.SEQ_NUM) , A.DESCR254 , A.DESCRLONG , A.FMS_LASTUPDDTTM FROM PS_PGM_RISK_NOTES A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 3 | CONCAT_PHYS_KEYS |
Character(120) | VARCHAR2(120) NOT NULL | Concatinated physical_inv keys |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |
| 6 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |