TAG_SEL_VW1

(SQL View)
 Index Back

Accounting Tag view


SELECT DISTINCT A.SETID , A.ACCOUNT_CODE ,B.EFFDT , B.EFF_STATUS , B.DESCR , B.TAG_GROUP , A.BALANCE_PCT ,C.OPRID , C.OPRCLASS , A.ACCTG_TAG_TYPE , D.OBJECTOWNERID FROM PS_ACCTG_TAG_HD A , PS_ACCTG_TAG_TBL B , PS_ACCTG_TAG_PERM C , PS_ACCTG_TAG_PROD D WHERE A.SETID = B.SETID AND A.SETID = c.setid AND A.SETID = D.SETID AND A.account_code = b.account_code AND a.account_code = c.account_code AND a.account_code = d.account_code AND B.EFFDT = D.EFFDT AND D.CHECKED = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 ACCOUNT_CODE Character(20) VARCHAR2(20) NOT NULL Accounting Tag
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 TAG_GROUP Character(15) VARCHAR2(15) NOT NULL Accounting Tag Group
7 BALANCE_PCT Character(1) VARCHAR2(1) NOT NULL Balanced Speedchart
N=No
Y=Yes
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
10 ACCTG_TAG_TYPE Character(1) VARCHAR2(1) NOT NULL Permission for Accounting Tag
C=Permission List
O=User List
U=All Users
11 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier