HR_REP_EE_VW

(SQL View)
 Index Back

Reporting Change XRef View

This view is used to generate notifications initiated by the transaction's component interface. This view was specifically created for this purpose so that the common Notification logic provided via the framework could be used to generate line level notifications for individual employees even though the transaction is set up at the header level. This record is used in the HR_TRANSACTIONS app packAge in the ApplySelfServiceData class.

SELECT A.TRANSACTION_NBR , B.EMPLID , B.EMPL_RCD , B.JOB_DESCR_SS , B.POSITION_FLAG , 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 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.
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 JOB_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Job Title
5 POSITION_FLAG Character(1) VARCHAR2(1) NOT NULL Position Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

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

12 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

13 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