GM_PT_ACC_LVL_V

(SQL View)
 Index Back

Access Level Work View by Empl


SELECT EMPLID , 'AWD' , BUSINESS_UNIT , CONTRACT_NUM , ' ' , ' ' , AWARD_FLAG , ' ' , PERSONNEL_FLG , END_DT , CREATEDTTM , LASTUPDDTTM , LASTUPDOPRID FROM PS_GM_PT_ACC_LVL2 UNION SELECT EMPLID , 'PRJ' , BUSINESS_UNIT , CONTRACT_NUM , BUSINESS_UNIT_PC , PROJECT_ID , ' ' , PROJECT_FLG , PERSONNEL_FLG , END_DT , CREATEDTTM , LASTUPDDTTM , LASTUPDOPRID FROM PS_GM_PT_ACC_LVL3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACCESS_LEVEL Character(4) VARCHAR2(4) NOT NULL Access Type is either Informational, Default Value, Key, System Generated Value, or a Field that causes down stream processing.
AWD=Award
BLNK=Blanket
DVSN=Division
EMPL=Employee
PIPM=PI/Project Manager
PRJ=Project
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
5 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
7 AWARD_FLAG Character(1) VARCHAR2(1) NOT NULL Award Location

Y/N Table Edit

8 PROJECT_FLG Character(1) VARCHAR2(1) NOT NULL Assign To Project
N=No
Y=Yes

Y/N Table Edit

9 PERSONNEL_FLG Character(1) VARCHAR2(1) NOT NULL Personnel Page

Y/N Table Edit

10 END_DT Date(10) DATE End Date
11 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.