PSPTDEFSEC_GRP

(SQL Table)
Index Back

Definition Groups

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OBJGROUPID Character(18) VARCHAR2(18) NOT NULL Object Group ID
2 OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name
3 PTKEYVALUE1 Character(150) VARCHAR2(150) NOT NULL Object Value 1
4 PTKEYVALUE2 Character(150) VARCHAR2(150) NOT NULL Object Value 2
5 PTKEYVALUE3 Character(150) VARCHAR2(150) NOT NULL Object Value 3
6 PTKEYVALUE4 Character(150) VARCHAR2(150) NOT NULL Object Value 4
7 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
8 PTKEYVALUE5 Character(150) VARCHAR2(150) NOT NULL Object Value 5
9 PTKEYVALUE6 Character(150) VARCHAR2(150) NOT NULL Object Value 6
10 PTKEYVALUE7 Character(150) VARCHAR2(150) NOT NULL Object Value 7
11 PTKEYVALUE8 Character(150) VARCHAR2(150) NOT NULL Object Value 8
12 PTKEYVALUE9 Character(150) VARCHAR2(150) NOT NULL Object Value 9
13 PTKEYVALUE10 Character(150) VARCHAR2(150) NOT NULL Object Value 10
14 PTKEYVALUE11 Character(150) VARCHAR2(150) NOT NULL Object Value 11
15 PTKEYVALUE12 Character(150) VARCHAR2(150) NOT NULL Object Value 12
16 PTKEYVALUE13 Character(150) VARCHAR2(150) NOT NULL Object Value 13
17 PTKEYVALUE14 Character(150) VARCHAR2(150) NOT NULL Object Value 14
18 PTKEYVALUE15 Character(150) VARCHAR2(150) NOT NULL Obejct Value 15
19 PTKEYVALUE16 Character(150) VARCHAR2(150) NOT NULL Object Value 16
20 DYNAMIC_FLAG Character(1) VARCHAR2(1) NOT NULL Dynamic Flag

Y/N Table Edit

Default Value: N