OPRIDRUN_CNTL_IDEMPLIDNAMEC=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
EMPL_REG_T5_BRA(SQL Table) |
Index Back |
|---|---|
Employee Registry BRAEmployee Registry Report Temp 5 BRA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME |
Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
| 6 | RELATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Relationship Descr |
| 7 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 8 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |
| 9 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |