RF_APP_LINE_TMP (SQL Table)	Index Back
Service Order Approval Info Temporary record used to display the Approval Information on the Service Order in a grid format.

RF_APP_LINE_TMP

(SQL Table)

Service Order Approval Info

Temporary record used to display the Approval Information on the Service Order in a grid format.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 APPROVAL_DT Date(10) DATE Date of Approval

2 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

3 APPROVAL_REQ_FLAG Character(1) VARCHAR2(1) NOT NULL This field specifies whether the approval is required for the activity.
N=No
Y=Yes

4 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to determine if approval is required for this inventory item.
A=Approved
P=Pending

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	APPROVAL_DT	Date(10)	DATE	Date of Approval
2	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
3	APPROVAL_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field specifies whether the approval is required for the activity. N=No Y=Yes
4	APPROVED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to determine if approval is required for this inventory item. A=Approved P=Pending