HR_MSSCT_ATT_VW (SQL View)	Index Back
HTML Email - Attachments Used to retrieve data for the attachments section of HTML email

HR_MSSCT_ATT_VW

(SQL View)

HTML Email - Attachments

Used to retrieve data for the attachments section of HTML email

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE , B.DESCR60 , B.WF_STATUS , B.HR_MSS_CT_NAME , B.LASTUPDDTTM , %Sql(HR_HT_EMAIL_DATE,%DatePart(B.LASTUPDDTTM)) , B.LASTUPDOPRID , REQ.NAME FROM PS_HR_MSS_CT_DAT A , PS_HR_MSS_CT_ATT B , PS_PERSON_NAME REQ , PSOPRDEFN OPR WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.ACTION_DT_SS = B.ACTION_DT_SS AND A.EFFSEQ = B.EFFSEQ AND B.LASTUPDOPRID = OPR.OPRID AND OPR.EMPLID =REQ.EMPLID

Related Language Record: HR_MSSCT_ATTLVW

# 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 ACTION_DT_SS Date(10) DATE Termination Date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

6 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

8 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

9 HR_MSS_CT_NAME Character(25) VARCHAR2(25) NOT NULL Compound Transaction Name

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 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

12 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

13 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	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	ACTION_DT_SS	Date(10)	DATE	Termination Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
6	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
7	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
8	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
9	HR_MSS_CT_NAME	Character(25)	VARCHAR2(25) NOT NULL	Compound Transaction Name
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	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
12	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name