TAG_SEL_VW

(SQL View)
 Index Back

Accounting Tag view


SELECT DISTINCT A.SETID , A.ACCOUNT_CODE , 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 = ( SELECT MAX(B1.EFFDT) FROM PS_ACCTG_TAG_TBL B1 WHERE B.SETID = B1.SETID AND b.account_code = b1.account_code) AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_ACCTG_TAG_PROD D1 WHERE D.SETID = D1.SETID AND D.account_code = D1.account_code) 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 TAG_GROUP Character(15) VARCHAR2(15) NOT NULL Accounting Tag Group
5 BALANCE_PCT Character(1) VARCHAR2(1) NOT NULL Balanced Speedchart
N=No
Y=Yes
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
8 ACCTG_TAG_TYPE Character(1) VARCHAR2(1) NOT NULL Permission for Accounting Tag
C=Permission List
O=User List
U=All Users
9 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier