HRCD_XPT_RUNCTL

(SQL Table)
Index Back

Run Control record

Run control record for HRCD export

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %Date

3 DOWNLOAD_TYPE Character(1) VARCHAR2(1) NOT NULL Download File Type
E=MS Office Excel
V=MS Office Visio
4 EXPORT_CONTENT Character(4) VARCHAR2(4) NOT NULL Export content: Profile or Org Chart
OGCT=Org Chart
PRFL=Profile
5 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
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
8 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

Prompt Table: HRCD_JBTRPRT_VW

9 TREE_EFFDT Date(10) DATE Effective date of the Tree

Default Value: %date

10 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
11 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier

Prompt Table: HRMH_MATRX_DEFN

12 ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
1=By Dept Security Tree
2=By Supervisor ID
3=By Department Manager ID
4=By Reports To Position
5=By Part Posn Mgmt Supervisor
6=By Part Posn Mgmt Dept Mgr ID
7=By Group ID
13 HR_DR_ALLOW_IND Character(1) VARCHAR2(1) NOT NULL Allow Indirect Reports

Y/N Table Edit

14 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
15 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
16 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
17 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID
18 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
19 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code