| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRCD_FLDMAP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Company Directory
|
| 2 |
HRCD_SECTION_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Company Directory Setup
NDAT=Org Chart - Node Attributes
PRCD=Profile - HR Details
PRCN=Profile - Contact Information
TSUM=General
|
| 3 |
ACTIVE_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Definition Active or Inactive?
A=Active
I=Inactive
Default Value: A
|
| 4 |
HRCD_DISPLAY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Company Directory field mapping display type
ACTN=Action Button
DROP=Drop-Down
HTML=HTML
LINK=Hyperlink
MAIL=Email Link
TELE=Telephone Number with Label
TEXT=Text
TXLB=Text/Label
Default Value: TXLB
|
| 5 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
PSRECDEFN
|
| 6 |
HRCD_FIELDNAME_SRC |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Fieldname
Prompt Table:
PSRECFIELDALL
|
| 7 |
HR_USE_XLAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display As Xlat
L=Use Long Xlat Value
S=Use Short Xlat Value
|
| 8 |
PARENTRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Parent Record Name
Prompt Table:
PSRECDEFN
|
| 9 |
LABEL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table:
HRCD_FLDLABL_VW
|
| 10 |
HR_LABEL_DISP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Display Type
L=Display Long Label
S=Display Short Label
|
| 11 |
HRCD_SHOW_LABEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Label When No Value
Y/N Table Edit
Default Value: N
|
| 12 |
HRCD_MSG_SET |
Number(5,0) |
INTEGER NOT NULL |
Label Message Set Number
|
| 13 |
HRCD_MSG_NBR |
Number(5,0) |
INTEGER NOT NULL |
Label Message Number
|
| 14 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
PSPACKAGROOT_VW
|
| 15 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table:
PSPACKAGPATH_VW
|
| 16 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
PSPACKAGCLAS_VW
|
| 17 |
METHODNAME |
Character(32) |
VARCHAR2(32) NOT NULL |
Method Name
|
| 18 |
METHODNAME2 |
Character(32) |
VARCHAR2(32) NOT NULL |
Method Name
|
| 19 |
HRCD_CLICK_METHOD |
Character(32) |
VARCHAR2(32) NOT NULL |
Click Handler Method Name
|
| 20 |
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.
Y/N Table Edit
Default Value: N
|
| 21 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 22 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|