PA_QDRO_COM

(SQL Table)
Index Back

QDRO Related Documents

This 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
3 QDRO_DOC_DT Date(10) DATE Date a QDRO document sent/recv
4 PA_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
5 IN_OUT Character(1) VARCHAR2(1) NOT NULL In/Out
I=In
O=Out
6 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Document Type
L=Letter
N=Notice
O=Other
Q=Request
R=Report
7 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID
8 DOC_RECIPIENT Character(1) VARCHAR2(1) NOT NULL Document Recipient
E=Employee
O=Other
Q=QDRO Recipient
R=Representative
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 STREET1 Character(30) VARCHAR2(30) NOT NULL Street (Line 1)
11 STREET2 Character(30) VARCHAR2(30) NOT NULL Street (Line 2)
12 CITY Character(30) VARCHAR2(30) NOT NULL City
13 STATE Character(6) VARCHAR2(6) NOT NULL State
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
15 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
16 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
17 COMMENT_DT Date(10) DATE Comment Date
18 COMMENTS Long Character CLOB Comment