HRCD_DT_EMPHRCD_DT_MGRA=Admin Add
AM=Dotted Line Manager
AR=Dotted Line Report
R=Admin Remove
RM=Dotted Line Manager
RR=Dotted Line Report
HRCD_DT_EMP_VW(SQL View) |
Index Back |
|---|---|
Report Details for Email Appr |
| SELECT A.HRCD_DT_EMP ,A.HRCD_DT_MGR ,C.NAME_DISPLAY ,D.NAME_DISPLAY ,A.HRCD_DTLN_ACTION ,A.HRCD_DT_CREATEDBY ,A.HRCD_DT_CREATEDATE ,%Sql(HR_HT_EMAIL_DATE,A.HRCD_DT_CREATEDATE) ,B.NAME_DISPLAY ,X.XLATLONGNAME FROM PS_HRCD_DT_APR A , PS_PERSON_NAME B ,PS_PERSON_NAME C ,PS_PERSON_NAME D ,PSXLATITEM X WHERE A.HRCD_DT_CREATEDBY = B.EMPLID AND A.HRCD_DT_EMP = C.EMPLID AND A.HRCD_DT_MGR = D.EMPLID AND A.HRCD_DTLN_ACTION = X.Fieldvalue AND X.FIELDNAME='HRCD_DTLN_ACTION' AND %EffdtCheck(PSXLATITEM X1,X,%CurrentDatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRCD_DT_EMP |
Character(11) | VARCHAR2(11) NOT NULL | Dotted Line Employee |
| 2 | HRCD_DT_MGR |
Character(11) | VARCHAR2(11) NOT NULL | Dotted Line Manager |
| 3 | HRCD_NAME_EMP | Character(50) | VARCHAR2(50) NOT NULL | Report Name |
| 4 | HRCD_NAME_MGR | Character(50) | VARCHAR2(50) NOT NULL | Manager Name |
| 5 | HRCD_DTLN_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Add
A=Admin Add AM=Dotted Line Manager AR=Dotted Line Report R=Admin Remove RM=Dotted Line Manager RR=Dotted Line Report |
| 6 | HRCD_DT_CREATEDBY | Character(11) | VARCHAR2(11) NOT NULL | DottedLine Created By |
| 7 | HRCD_DT_CREATEDATE | Date(10) | DATE | DottedLine Creation Date |
| 8 | HRCD_DTLN_CREATE | Character(15) | VARCHAR2(15) NOT NULL | Date Requested |
| 9 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 10 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |