EMPLIDQDRO_IDPrompt Table: PA_ALT_PAYEE_VW
BENEFIT_PLANPrompt Table: PA_PLAN_VW
Default Value: PA_DRODAT.DATE_RECEIVED
Default Value: PA_DRODAT.COURT_NAME
Prompt Table: PA_DRO_DOC_VW
PA_QDRODAT(SQL Table) |
Index Back |
|---|---|
QDRO 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 |
| 2 | QDRO_ID |
Character(11) | VARCHAR2(11) NOT NULL |
QDRO ID
Prompt Table: PA_ALT_PAYEE_VW |
| 3 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_PLAN_VW |
| 4 | DATE_RECEIVED | Date(10) | DATE |
Date Received
Default Value: PA_DRODAT.DATE_RECEIVED |
| 5 | COURT_NAME | Character(60) | VARCHAR2(60) NOT NULL |
Court Name Issuing Order
Default Value: PA_DRODAT.COURT_NAME |
| 6 | COURT_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL |
Court Document ID
Prompt Table: PA_DRO_DOC_VW |
| 7 | QDRO_ISSUE_DT | Date(10) | DATE | Date Issued |
| 8 | QDRO_JOINED_DT | Date(10) | DATE | Date Joined |
| 9 | QDRO_OFFSET_DT | Date(10) | DATE | Offset Payout Date |
| 10 | QDRO_AMOUNT | Number(13,2) | DECIMAL(12,2) NOT NULL | QDRO Dollar Amount |