| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 JPM_PROF_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile Transaction Type
H=Historical
J=Non-Person
P=Person
|
| 2 |
JPM_JP_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
JPM Profile Actions for selection. These actions are included in a drop down list on Profiles.
00=[Select Action]
01=View As Of Another Date
02=Copy From Job Profile
03=Select Another Profile Type
04=View Pending Items
05=Update Profile Groups
06=Select Another Employee
50=View People In This Job
51=Find People Who Match Profile
52=View Related Job Profiles
53=View Profile in Job Matrix
56=Manage Change Requests
60=Express Interest for Employee
61=View Denied Items
62=View Saved Items
63=Express Interest
70=Search and Compare Profiles
|
| 3 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 4 |
JPM_ADM_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Admin Access
N=No
Y=Yes
|
| 5 |
JPM_MGR_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager Access
N=No
Y=Yes
|
| 6 |
JPM_EMP_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Access
N=No
Y=Yes
|
| 7 |
JPM_ACTION_ROLES |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile Action Roles
1=Admin only
2=Manager only
3=Employee Only
4=Manager and Employee
5=All
|
| 8 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
|