HR_RWORK_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PERS_SRCH_GBL
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	HR_RW_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Remote Worker Type(Fully remote/Hybrid) F=Fully Remote H=Hybrid
5	HR_RW_LOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Remote Worker Location Type H=Home O=Other W=Workplace
6	HR_RW_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Remote Work Location
7	RW_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	Percentage
8	RW_PERCENT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Remote Work Percent
9	RW_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Remote Worker Type
10	RW_DAY1	Character(1)	VARCHAR2(1) NOT NULL	New fiedl to display Monday A=Active I=Inactive
11	RW_DAY2	Character(1)	VARCHAR2(1) NOT NULL	New fiedl to display Monday A=Active I=Inactive
12	RW_DAY3	Character(1)	VARCHAR2(1) NOT NULL	New fiedl to display Wednesday A=Active I=Inactive
13	RW_DAY4	Character(1)	VARCHAR2(1) NOT NULL	New fiedl to display Thursday A=Active I=Inactive
14	RW_DAY5	Character(1)	VARCHAR2(1) NOT NULL	New fiedl to display Friday A=Active I=Inactive
15	RW_DAY6	Character(1)	VARCHAR2(1) NOT NULL	New fiedl to display Saturday A=Active I=Inactive
16	RW_DAY7	Character(1)	VARCHAR2(1) NOT NULL	New fiedl to display Sunday A=Active I=Inactive
17	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
18	HR_RW_REASON	Character(60)	VARCHAR2(60) NOT NULL	Remote Worker Reason
19	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.