EMPLIDPrompt Table: PERS_SRCH_GBL
COURT_DOC_ID01=default
Prompt Table: DEP_BENEF_VW
PA_DRODAT(SQL Table) |
Index Back |
|---|---|
DRO DataThis is an employee table for QDRO. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 2 | COURT_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Court Document ID |
| 3 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEP_BENEF_VW |
| 4 | COURT_NAME | Character(60) | VARCHAR2(60) NOT NULL | Court Name Issuing Order |
| 5 | DATE_RECEIVED | Date(10) | DATE | Date Received |
| 6 | DRO_CANCEL_DT | Date(10) | DATE | Cancellation Date |
| 7 | DRO_CANCEL_DOC | Character(25) | VARCHAR2(25) NOT NULL | Cancellation Document ID |
| 8 | COMMENTS | Long Character | CLOB | Comment |