RS_RSRCGP_RS_VW

(SQL View)
Index Back

Resource Group view for RS


SELECT SYSTEM_SOURCE ,OPRID ,RS_RSRCGRP_NAME ,OPRID_ENTERED_BY FROM %Table(RS_RSRCGRP_FAV ) WHERE SYSTEM_SOURCE = 'RS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RS_RSRCGRP_NAME Character(15) VARCHAR2(15) NOT NULL Resource Group ID
4 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes