RO_LINE_PORT_VW

(SQL View)
Index Back

Portin Line View

Order line portin view. Combines RO_LINE with the portin details

SELECT a.CAPTURE_ID , a.UID20 , a.LINE_NBR , a.INST_PROD_ID , a.PRODUCT_ID , a.STATUS_CODE , a.RBTNUMBER , b.PHONE_AREA , b.PHONE , b.CARRIER_ID_MOBILE , b.ACCOUNT_NUMBER , b.NATIONAL_ID , b.PHONE_PIN , b.PHONE_CONTACT , b.PAC_CODE , b.REQUEST_DT , b.PHONE_TEMP , b.PROFILE_CM_SEQ_ADD , b.UID20F_ADDR ,b.VALIDATE_DETAILS FROM PS_RO_LINE a , PS_RO_LINE_PORTIN b WHERE a.CAPTURE_ID = b.CAPTURE_ID AND a.PORT_IN_FLAG='Y' AND a.UID20 = b.UID20

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
2 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
3 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
4 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code
7 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
8 PHONE_AREA Character(10) VARCHAR2(10) NOT NULL Telephone area code for use in number management
9 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
10 CARRIER_ID_MOBILE Character(10) VARCHAR2(10) NOT NULL Wireless Carrier ID for tracking wireless carrier information
11 ACCOUNT_NUMBER Character(20) VARCHAR2(20) NOT NULL Account number ---------> FSI Account
12 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
13 PHONE_PIN Character(10) VARCHAR2(10) NOT NULL Phone pin number for wireless portin request
14 PHONE_CONTACT Character(24) VARCHAR2(24) NOT NULL Used for contact phone number
15 PAC_CODE Character(9) VARCHAR2(9) NOT NULL PAC Code issues by wireless carriers for transferring phone numbers.
16 REQUEST_DT Date(10) DATE Request date field to store request date value.
17 PHONE_TEMP Character(24) VARCHAR2(24) NOT NULL Temporary phone number used when transferring service
18 PROFILE_CM_SEQ_ADD Number(31,0) DECIMAL(31) NOT NULL This field is used to store the profile contact method sequence number for an address.
19 UID20F_ADDR Character(20) VARCHAR2(20) NOT NULL Foreign UID
20 VALIDATE_DETAILS Character(3) VARCHAR2(3) NOT NULL Field to indicate if the port-in details have been validated outside of the system.
FAX=Fax
PHN=Phone Call
SYS=Automatic
WEB=External Website