GPHK_MSG_SRCH2(SQL View) |
Index Back |
|---|---|
Message SearchMessage Search |
| SELECT DISTINCT CAL_RUN_ID ,CAL_ID ,MESSAGE_SET_NBR , MESSAGE_NBR FROM PS_GP_MESSAGES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | |
| 2 | Character(18) | VARCHAR2(18) NOT NULL | calendar id | |
| 3 | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. | |
| 4 | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |