HR_REP_REQ_CMTS(SQL View) |
Index Back |
---|---|
Wkflow for Reporting Change SSThis record is a child of HR_MGR_REP_DAT and is used to store data about each step of the worflow approval process for a Reporting Change request. |
SELECT TRANSACTION_NBR ,COMMENTS FROM PS_HR_MGR_REP_STA WHERE SEQNO = 1 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
2 | COMMENTS | Long Character | CLOB | Comment |