HR_MGR_RPT_VW

(SQL View)
 Index Back

Wkflow View - HR_MGR_RPT_VW

Contains workflow status information for the HR Request Employee Transfer transaction

SELECT B.EMPLID , B.EMPL_RCD , A.ACTION_DT_SS , A.TRANSACTION_NBR , A.WF_STATUS , A.HR_REPCHNG_REASON , A.SUPERVISOR_ID , A.REPORTS_TO , B.ORIGINATORID , B.TRANSACTION_NAME , B.UPD_BY_USERID , B.UPD_DTTM , B.MANUAL_UPD_USERID , B.MANUAL_UPD_DTTM , B.SS_STAT_INDICATOR , B.SS_WARNING_FLG , B.SS_FUTURE_FLG FROM PS_HR_MGR_REP_DAT A ,PS_HR_REPORT_TRANS B WHERE A.TRANSACTION_NBR = B.TRANSACTION_NBR

# 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 Rcd Nbr
3 ACTION_DT_SS Date(10) DATE Termination Date
4 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.
5 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
6 HR_REPCHNG_REASON Character(3) VARCHAR2(3) NOT NULL Action / Reason
DTA=Reporting Change
7 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

Prompt Table: PERSON

8 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

Prompt Table: POSITION_DATA

9 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
10 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
11 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
12 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
13 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
14 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
15 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

16 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

17 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