SCR_PIVOT3_VW

(SQL View)
 Index Back

SCR trend pivot


SELECT SCR_ID ,TYPE_CHANGE ,ATTRIBUTE_LVL ,SCR_STATUS ,SETID ,VENDOR_NAME_SHORT ,SUBMITTER_TYPE , 'D' , DATE_CHAR26 ,REQUESTOR_NAM ,%DatePart(FMS_DTTM_STAMP) ,last_update_date ,FMS_DTTM_STAMP FROM PS_SCR_PIVOT_VW UNION SELECT SCR_ID ,TYPE_CHANGE ,ATTRIBUTE_LVL ,SCR_STATUS ,SETID ,VENDOR_NAME_SHORT ,SUBMITTER_TYPE , 'W' , DATE_CHAR ,REQUESTOR_NAM ,%DatePart(FMS_DTTM_STAMP) ,last_update_date ,FMS_DTTM_STAMP FROM PS_SCR_PIVOT_VW UNION SELECT SCR_ID ,TYPE_CHANGE ,ATTRIBUTE_LVL ,SCR_STATUS ,SETID ,VENDOR_NAME_SHORT ,SUBMITTER_TYPE , 'M' , MONTH_SCR ,REQUESTOR_NAM ,%DatePart(FMS_DTTM_STAMP) ,last_update_date ,FMS_DTTM_STAMP FROM PS_SCR_PIVOT_VW UNION SELECT SCR_ID ,TYPE_CHANGE ,ATTRIBUTE_LVL ,SCR_STATUS ,SETID ,VENDOR_NAME_SHORT ,SUBMITTER_TYPE , 'Q' , year_scr %Concat '-' %Concat QUARTER_SCR ,REQUESTOR_NAM ,%DatePart(FMS_DTTM_STAMP) ,last_update_date ,FMS_DTTM_STAMP FROM PS_SCR_PIVOT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Request ID
2 TYPE_CHANGE Character(2) VARCHAR2(2) NOT NULL Type of Change
AD=Addresses
AR=Reporting Elements
AT=Attachments
BA=Bank Accounts
CA=Categorizations
CT=Contacts
DI=Dup. Invoice Settings
GC=Gov. Classifications
ID=ID Numbers
PP=Payment Preferences
PQ=Profile Questions
RA=Supplier Rating
SC=SIC Codes
SR=Sup. Relationships
VN=Company Profile
VT=Vat Registration
3 ATTRIBUTE_LVL Character(2) VARCHAR2(2) NOT NULL Attribute Level
AD=Addresses
CA=Categorization
CP=Company Profile
CT=Contacts
PP=Payment Profile
4 SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Status
A=Approved
B=Request Editor More Info..
B=Request Editor More Info..
C=Pending Editor Review
C=Pending Editor Review
E=Update Error
I=Integrity Error
M=Request Additional Information
P=Pending Approval
R=Rejected
S=Save for Later
U=Database Updated
W=Withdrawn
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
7 SUBMITTER_TYPE Character(1) VARCHAR2(1) NOT NULL Submitter Type
E=External
I=Internal
8 TREND_INTERVAL Character(1) VARCHAR2(1) NOT NULL Trend Interval
D=Daily
M=Monthly
Q=Quarterly
W=Weekly
9 RANGE_TREND Character(30) VARCHAR2(30) NOT NULL Range
10 REQUESTOR_NAM Character(70) VARCHAR2(70) NOT NULL Requestor Name
11 REQUEST_DATE Date(10) DATE Requested
12 LAST_UPDATE_DATE Date(10) DATE Date of last update
13 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.