RETRODEDMAS_VW(SQL View) | 
Index Back | 
|---|---|
Mass Retro Ded Request ViewThis is the view of RETRODEDMAS_TBL where the MASS_PRCS_FLAG = 'L' and DELETE_REQUEST = 'N'. | 
| select mass_retro_rqst_id, descr from PS_RETRODEDMAS_TBL where mass_prcs_flag = 'L' and delete_request = 'N' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Mass Retro Request ID | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |