SPB_REPL_LOG_VW

(SQL View)
 Index Back

Replace SC Log View

Replace SC Log View

SELECT A.FROM_SRVC_COD , A.RUN_DTTM , A.SEQNUM , A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.WORK_ORDER_ID , A.TO_SRVC_COD , A.TO_TEAMID , A.DEFAULT_TEAM_MEM , B.NAME , A.SC_REPLACE_TXNTYPE , A.INCL_CLOSED , A.INCL_FINALIZED , A.SCHD_REPLACESC_EM , A.COMMENTS_254 , A.ROW_CREATE_USER FROM PS_SPB_REPLASC_LOG A , PS_SPB_PERSON_TBL B WHERE A.FROM_SRVC_COD = B.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FROM_SRVC_COD Character(15) VARCHAR2(15) NOT NULL Service Coordinator
2 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time
3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
8 TO_SRVC_COD Character(15) VARCHAR2(15) NOT NULL Service Coordinator
9 TO_TEAMID Character(15) VARCHAR2(15) NOT NULL Team ID
10 DEFAULT_TEAM_MEM Character(15) VARCHAR2(15) NOT NULL Default Team Member
11 NAME50 Character(50) VARCHAR2(50) NOT NULL name field of length 50
12 SC_REPLACE_TXNTYPE Character(1) VARCHAR2(1) NOT NULL Transcation Type
R=Requisition Through Work Order
W=Work Order Only
13 INCL_CLOSED Character(1) VARCHAR2(1) NOT NULL Include Closed Information
14 INCL_FINALIZED Character(1) VARCHAR2(1) NOT NULL Include Finalized Work Orders
15 SCHD_REPLACESC_EM Character(1) VARCHAR2(1) NOT NULL SCHEDULE SERVICE COORDINATOR REPLACEMENT EMAIL
16 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
17 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By