HRCD_SETUP_M_O1

(SQL View)
 Index Back

Co. Directory-Node Attrib Vw

Node attributes data mapping

SELECT A.HRCD_FLDMAP_ID , A.HRCD_SECTION_TYPE , B.HRCD_ORGVIEW_TYPE , A.ACTIVE_INACTIVE , A.HRCD_DISPLAY_TYPE , A.RECNAME , A.HRCD_FIELDNAME_SRC , A.HR_USE_XLAT , A.PARENTRECNAME , A.LABEL_ID , A.HR_LABEL_DISP_FLAG , A.HRCD_SHOW_LABEL , A.HRCD_MSG_SET , A.HRCD_MSG_NBR , A.PACKAGEROOT , A.QUALIFYPATH , A.APPCLASSID , A.METHODNAME , A.METHODNAME2 , A.HRCD_CLICK_METHOD , A.SYSTEM_DATA_FLG , B.HRCD_LINE_NBR FROM PS_HRCD_SETUP_MAP A , PS_HRCD_SETUP_NDAT B WHERE A.HRCD_FLDMAP_ID = B.HRCD_FLDMAP_ID AND A.HRCD_SECTION_TYPE = 'NDAT' UNION SELECT ' ' , 'NDAT' , B.HRCD_ORGVIEW_TYPE , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , B.HRCD_LINE_NBR FROM PS_HRCD_SETUP_NDAT B WHERE %Sql(FUNCLIB_HR_STRING_RTRIM,B.HRCD_FLDMAP_ID) IS NULL

# 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 HRCD_ORGVIEW_TYPE Character(4) VARCHAR2(4) NOT NULL This field stores the Org View Type.
CDFL=Company Directory Fluid
CDOV=Company Directory
MGSS=Direct-Line Reports
MTRX=Matrix Reports
4 ACTIVE_INACTIVE Character(1) VARCHAR2(1) NOT NULL Definition Active or Inactive?
A=Active
I=Inactive

Default Value: A

5 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

6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

7 HRCD_FIELDNAME_SRC Character(18) VARCHAR2(18) NOT NULL Source Fieldname

Prompt Table: PSRECFIELDALL

8 HR_USE_XLAT Character(1) VARCHAR2(1) NOT NULL Display As Xlat
L=Use Long Xlat Value
S=Use Short Xlat Value
9 PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name

Prompt Table: PSRECDEFN

10 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

11 HR_LABEL_DISP_FLAG Character(1) VARCHAR2(1) NOT NULL Label Display Type
L=Display Long Label
S=Display Short Label
12 HRCD_SHOW_LABEL Character(1) VARCHAR2(1) NOT NULL Show Label When No Value

Y/N Table Edit

Default Value: N

13 HRCD_MSG_SET Number(5,0) INTEGER NOT NULL Label Message Set Number
14 HRCD_MSG_NBR Number(5,0) INTEGER NOT NULL Label Message Number
15 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

16 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

17 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: PSPACKAGCLAS_VW

18 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
19 METHODNAME2 Character(32) VARCHAR2(32) NOT NULL Method Name
20 HRCD_CLICK_METHOD Character(32) VARCHAR2(32) NOT NULL Click Handler Method Name
21 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

22 HRCD_LINE_NBR Number(3,0) SMALLINT NOT NULL Attribute Number