PA_CLC_EMP_VW(SQL View) |
Index Back |
|---|---|
Calculation Employee View |
| SELECT DISTINCT C.OPRID , A.CALC_NAME , B.EMPLID , B.EVENT_DT , A.CALC_REASON , B.NAME , A.BIRTHDATE , A.SPOUSE_BIRTHDATE , A.CALC_EXEC_TS , A.PROCESS_INSTANCE , B.BIRTHDATE , B.SPOUSE_BIRTHDATE , B.MAR_STATUS , B.SEX , B.SPOUSE_NAME FROM PS_PA_CALCULATION A , PS_PA_CLC_EMP B , PS_PERS_SRCH_GBL C WHERE A.CALC_NAME = B.CALC_NAME AND B.EMPLID = C.EMPLID |
| # | 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 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 4 | EVENT_DT | Date(10) | DATE |
Event Date
Default Value: %date |
| 5 | CALC_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Calculation Reason Code
DEF=TV-Deferred Pymt DIS=Disability DTH=Death QDR=QDRO Alternate Payee RET=Retirement TER=TV-Immediate Pymt WEB=Web Estimate |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | BDATE_OVRD | Date(10) | DATE | Birthdate Override |
| 8 | SPOUSE_BDATE_OVRD | Date(10) | DATE | Spouse Birthdate Override |
| 9 | CALC_EXEC_TS | DateTime(26) | TIMESTAMP | Calc Execution Timestamp |
| 10 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 11 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 12 | SPOUSE_BIRTHDATE | Date(10) | DATE | Spouse Birth Date |
| 13 | 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 |
| 14 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 15 | SPOUSE_NAME | Character(40) | VARCHAR2(40) NOT NULL | Spouse Name |