HR_RW_AWE_VW

(SQL View)
Index Back

Remote Worker Approval

Remote Worker Approval - This view is used to display the details for approval

SELECT A.EMPLID ,A.EMPL_RCD ,A.START_DATE ,A.END_DATE ,A.DAYS ,A.HR_RW_TYPE ,A.REG_REGION ,A.HR_RW_REASON ,A.HR_RW_LOC_TYPE ,A.LOCATION , %subrec(ADDRESS_SBR, A) ,A.RW_PERCENT ,A.HR_RW_TRACK_DAYS , %subrec(HR_RW_DAYS, A) ,A.HR_RW_AVG_MONTH ,A.HR_RW_AVG_WEEK , %subrec(WF_PROC_SBR, A) ,A.WF_STATUS ,A.RW_SS_STATUS ,A.AGC_LIST_ID ,A.PTAI_LIST_ID ,A.HR_RW_DATA_SOURCE ,NM.NAME_DISPLAY ,( SELECT XL.XLATLONGNAME FROM PSXLATITEM XL WHERE XL.FIELDNAME = 'HR_RW_TYPE' AND XL.FIELDVALUE = A.HR_RW_TYPE AND %EffdtCheck(PSXLATITEM XL2, XL, %CurrentDateIn)) ,( SELECT XL1.XLATLONGNAME FROM PSXLATITEM XL1 WHERE XL1.FIELDNAME = 'HR_RW_LOC_TYPE' AND XL1.FIELDVALUE = A.HR_RW_LOC_TYPE AND %EffdtCheck(PSXLATITEM XL3, XL1, %CurrentDateIn) ) , '' ,'EONC_INFO_ICN','' FROM PS_HR_RWORK_TBL A , PS_PERSON_NAME NM WHERE NM.EMPLID = A.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
4 END_DATE Date(10) DATE End Date
5 DAYS Number(3,0) SMALLINT NOT NULL Days
6 HR_RW_TYPE Character(1) VARCHAR2(1) NOT NULL Remote Worker Type(Fully remote/Hybrid)
F=Fully Remote
H=Hybrid
7 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
8 HR_RW_REASON Character(60) VARCHAR2(60) NOT NULL Remote Worker Reason
9 HR_RW_LOC_TYPE Character(1) VARCHAR2(1) NOT NULL Remote Worker Location Type
H=Home
O=Other
W=Workplace
10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
16 CITY Character(30) VARCHAR2(30) NOT NULL City
17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
24 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

28 RW_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Percentage
29 HR_RW_TRACK_DAYS Character(1) VARCHAR2(1) NOT NULL Remote Worker Track Days
M=Average Days Per Month
S=Specific Days Per Week
W=Average Days Per Week
30 RW_DAY1 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Monday
A=Active
I=Inactive

Default Value: I

31 RW_DAY2 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Monday
A=Active
I=Inactive

Default Value: I

32 RW_DAY3 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Wednesday
A=Active
I=Inactive

Default Value: I

33 RW_DAY4 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Thursday
A=Active
I=Inactive

Default Value: I

34 RW_DAY5 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Friday
A=Active
I=Inactive

Default Value: I

35 RW_DAY6 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Saturday
A=Active
I=Inactive

Default Value: I

36 RW_DAY7 Character(1) VARCHAR2(1) NOT NULL New fiedl to display Sunday
A=Active
I=Inactive

Default Value: I

37 HR_RW_AVG_MONTH Number(4,1) DECIMAL(3,1) NOT NULL Average Days Per Month
38 HR_RW_AVG_WEEK Number(4,1) DECIMAL(3,1) NOT NULL Average Days Per Month
39 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
40 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
41 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
42 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
43 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
44 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
45 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
A=Approved
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Errors Encountered
I=In Approval Process
M=Administrator Action Required
S=Success
W=Warnings Encountered

Default Value: I

46 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

Y/N Table Edit

Default Value: N

47 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

Y/N Table Edit

Default Value: N

48 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
49 RW_SS_STATUS Character(1) VARCHAR2(1) NOT NULL Health and Safety self-service status
A=Approved
D=Denied
I=Draft
M=Pushed Back
P=Pending Approval
S=Submitted
50 AGC_LIST_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer List Id
51 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
52 HR_RW_DATA_SOURCE Character(1) VARCHAR2(1) NOT NULL Remote worker Data Source
1=Employee Self Service
2=Manager Self Service
53 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
54 HR_RW_LONG_TYPE Character(30) VARCHAR2(30) NOT NULL Remote Worker Tyoe
55 HR_RW_LOC_LO_TYPE Character(30) VARCHAR2(30) NOT NULL Remote Worker Location Type
56 HR_RW_APPR_DAYS Character(100) VARCHAR2(100) NOT NULL Remote Worker Specific Days per week
57 EOPCIMAGE_ID Character(30) VARCHAR2(30) NOT NULL Image
58 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description