RBT_NUMAUDIT (SQL View)	Index Back
Number Audit This is the record definition for Number Audit Information used by Communication.

RBT_NUMAUDIT

(SQL View)

Number Audit

This is the record definition for Number Audit Information used by Communication.

SELECT b.RBTNUMBER , a.AUDIT_STAMP , a.KEY1 , a.AUDIT_OPRID , %Substring(a.NEWVALUE ,1 ,2) FROM PSAUDIT a , PS_RBT_NUMBER b WHERE a.KEY1 = %Sql(CAST_AS_CHAR,b.RBTNUMBER,15) AND a.FIELDNAME = 'RBTSTATUS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco

2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp

3 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key

4 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.

5 RBTSTATUS Character(2) VARCHAR2(2) NOT NULL Status for Telco
AG=Aging
AS=Active
AV=Available
BL=Blocked
PA=Activation-Pending
PE=Pending
PO=Ported-Out
RL=Released
RS=Reserved

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RBTNUMBER	Character(15)	VARCHAR2(15) NOT NULL	Number For Telco
2	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp
3	KEY1	Character(65)	VARCHAR2(65) NOT NULL	First Key
4	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
5	RBTSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Status for Telco AG=Aging AS=Active AV=Available BL=Blocked PA=Activation-Pending PE=Pending PO=Ported-Out RL=Released RS=Reserved