GP_ABS_SRCH_VW(SQL View) |
Index Back |
---|---|
Absence Event Definition.Absence Event Definition - Main view used for bsence Global Search |
SELECT DISTINCT E.EMPLID ,E.EMPL_RCD ,E.BGN_DT ,E.pin_take_num ,E.END_DT ,F.DESCR ,E.WF_STATUS ,E.TRANSACTION_NBR ,E.LAST_UPDT_DT ,F.LAST_UPDT_DTTM ,F.USED_BY ,G.EFFDT ,F.COUNTRY ,G.ABS_TYPE_OPTN ,E.ABSENCE_REASON ,E.ABS_ENTRY_SRC ,E.ACTION_DT_SS ,%DateAdd(E.LAST_UPDT_DT,1) FROM PS_GP_ABS_EVENT E , PS_GP_PIN F , PS_GP_ABS_TAKE G WHERE G.PIN_NUM = F.PIN_NUM AND G.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_GP_ABS_TAKE C_ED WHERE G.PIN_NUM = C_ED.PIN_NUM AND C_ED.EFFDT <= %CurrentDateIn) AND E.PIN_TAKE_NUM = F.PIN_NUM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | BGN_DT | Date(10) | DATE NOT NULL | Begin Date |
4 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
5 | END_DT | Date(10) | DATE | end date |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |
8 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
9 | LAST_UPDT_DT | Date(10) | DATE | Date of last Update |
10 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
11 | USED_BY | Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country |
12 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
14 | ABS_TYPE_OPTN | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
15 | ABSENCE_REASON | Character(3) | VARCHAR2(3) NOT NULL | absence reason |
16 | ABS_ENTRY_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Absence Entry Source
1=Administrator Absence Event 2=Time & Labor 3=Third Party 4=Employee Absence Request 5=Manager Absence Request 6=Employee Timesheet 7=Manager Timesheet A=Employee Extended Absence B=Manager Extended Absence C=Administrator Extended Absence D=Employee Desktop Integration |
17 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
18 | LAST_UPDATE_DT | Date(10) | DATE | Last Updated |