ACTN_CD_ADD_VW2 (SQL View)	Index Back
Action Code Search

ACTN_CD_ADD_VW2

(SQL View)

Action Code Search

SELECT SETID , SYSTEM_DEFINITION , ACTION_CODE , DESCR FROM PS_ACTION_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 SYSTEM_DEFINITION Character(1) VARCHAR2(1) NOT NULL System Defined
S=System Defined
U=User Defined

3 ACTION_CODE Character(4) VARCHAR2(4) NOT NULL Action Code
ALRT=Alert
CALL=Call the Customer
CRDT=Review Customer Credit Limit
DLTR=Dunning Letter
DNGD=Downgrade Credit Rating
FEBN=Follow up eBill Note
HOLD=Place Customer on Hold
OLTR=Send Other Letter
POD=Proof of Delivery
PRBK=Review Broken Promise Date
PRFO=Review Promise Date
REFR=Refer to Collection Agency
STMT=Send Statement of Account
WOFF=Write off Customer Balance

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SYSTEM_DEFINITION	Character(1)	VARCHAR2(1) NOT NULL	System Defined S=System Defined U=User Defined
3	ACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Action Code ALRT=Alert CALL=Call the Customer CRDT=Review Customer Credit Limit DLTR=Dunning Letter DNGD=Downgrade Credit Rating FEBN=Follow up eBill Note HOLD=Place Customer on Hold OLTR=Send Other Letter POD=Proof of Delivery PRBK=Review Broken Promise Date PRFO=Review Promise Date REFR=Refer to Collection Agency STMT=Send Statement of Account WOFF=Write off Customer Balance
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description