FT_JOB_GRADE

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
3 FT_VALID_GRD_GUID Character(36) VARCHAR2(36) NOT NULL Valid Grade GUID
4 FT_EFF_START_DATE Date(10) DATE Effective Start Date
5 FT_EFF_END_DATE Date(10) DATE Effective End Date
6 FT_BUS_GROUP_GUID Character(36) VARCHAR2(36) NOT NULL Business Group ID
7 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
8 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
9 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
10 FT_GRADE_GUID Character(36) VARCHAR2(36) NOT NULL Grade GUID
11 FT_POSITION_GUID Character(36) VARCHAR2(36) NOT NULL Position GUID
12 FT_JOB_GUID Character(36) VARCHAR2(36) NOT NULL Job GUID
13 FT_ACTN_OCCUR_GUID Character(36) VARCHAR2(36) NOT NULL Action Occurrence ID
14 FT_ATTR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Attribute Category
15 FT_ATTRIBUTE1 Character(1) VARCHAR2(1) NOT NULL Attribute
16 FT_ATTRIBUTE2 Character(1) VARCHAR2(1) NOT NULL Attribute
17 FT_ATTRIBUTE3 Character(1) VARCHAR2(1) NOT NULL Attribute
18 FT_ATTRIBUTE4 Character(1) VARCHAR2(1) NOT NULL Attribute
19 FT_ATTRIBUTE5 Character(1) VARCHAR2(1) NOT NULL Attribute
20 FT_ATTRIBUTE6 Character(1) VARCHAR2(1) NOT NULL Attribute
21 FT_ATTRIBUTE7 Character(1) VARCHAR2(1) NOT NULL Attribute
22 FT_ATTRIBUTE8 Character(1) VARCHAR2(1) NOT NULL Attribute
23 FT_ATTRIBUTE9 Character(1) VARCHAR2(1) NOT NULL Attribute
24 FT_ATTRIBUTE10 Character(1) VARCHAR2(1) NOT NULL Attribute
25 FT_ATTRIBUTE11 Character(1) VARCHAR2(1) NOT NULL Attribute
26 FT_ATTRIBUTE12 Character(1) VARCHAR2(1) NOT NULL Attribute
27 FT_ATTRIBUTE13 Character(1) VARCHAR2(1) NOT NULL Attribute
28 FT_ATTRIBUTE14 Character(1) VARCHAR2(1) NOT NULL Attribute
29 FT_ATTRIBUTE15 Character(1) VARCHAR2(1) NOT NULL Attribute
30 FT_ATTRIBUTE16 Character(1) VARCHAR2(1) NOT NULL Attribute
31 FT_ATTRIBUTE17 Character(1) VARCHAR2(1) NOT NULL Attribute
32 FT_ATTRIBUTE18 Character(1) VARCHAR2(1) NOT NULL Attribute
33 FT_ATTRIBUTE19 Character(1) VARCHAR2(1) NOT NULL Attribute
34 FT_ATTRIBUTE20 Character(1) VARCHAR2(1) NOT NULL Attribute
35 FT_ATTRIBUTE21 Character(1) VARCHAR2(1) NOT NULL Attribute
36 FT_ATTRIBUTE22 Character(1) VARCHAR2(1) NOT NULL Attribute
37 FT_ATTRIBUTE23 Character(1) VARCHAR2(1) NOT NULL Attribute
38 FT_ATTRIBUTE24 Character(1) VARCHAR2(1) NOT NULL Attribute
39 FT_ATTRIBUTE25 Character(1) VARCHAR2(1) NOT NULL Attribute
40 FT_ATTRIBUTE26 Character(1) VARCHAR2(1) NOT NULL Attribute
41 FT_ATTRIBUTE27 Character(1) VARCHAR2(1) NOT NULL Attribute
42 FT_ATTRIBUTE28 Character(1) VARCHAR2(1) NOT NULL Attribute
43 FT_ATTRIBUTE29 Character(1) VARCHAR2(1) NOT NULL Attribute
44 FT_ATTRIBUTE30 Character(1) VARCHAR2(1) NOT NULL Attribute
45 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
46 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

47 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

Default Value: N

48 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
49 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key