SS_EMAIL_TEXT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
2	SS_CONFIG_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Used in SS Framework 1=DB Updates N, Appr Reqd Y 2=DB Updates N, Appr Reqd N 3=DB Updates Y, Appr Reqd Y 4=DB Updates Y, Appr Reqd N 5=CI Administrator Option
3	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
4	CURRENT_COMP_USE	Character(3)	VARCHAR2(3) NOT NULL	Used in SS Framework ADM=Administrator APL=Approval List APR=Approver DFL=Default (Email Config Only) ORG=Originator STL=Status List STS=Status
5	SS_ROLETYPE	Character(3)	VARCHAR2(3) NOT NULL	Used in SS Framework ADM=Administrator APR=Approver INP=Interested Party ORG=Originator
6	NOTIFY_COMP_USE	Character(3)	VARCHAR2(3) NOT NULL	Used in SS Framework ADM=Administrator APL=Approval List APR=Approver DFL=Default (Email Config Only) ORG=Originator STL=Status List STS=Status
7	EMAIL_PART	Character(1)	VARCHAR2(1) NOT NULL	Used in SS Framework A=Approved Request B=Error and Warning Requests C=Body Close Area D=Denied Requests E=Error Requests F=Future Row Enc Requests I=Body Intro L=URL Area M=Submitted Request S=Subject Area U=Success DB Update Request W=Warnings Encountered
8	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
10	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.