INSTALLATION_RS(SQL Table) |
Index Back |
|---|---|
RM InstallationThis record is used to store the installation option for Resource Management. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RS_DEBUG_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Debug Mode On
0=Debug Mode Off 1=Debug Mode On Default Value: 0 |
| 2 | EVALUATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Type
A=Approved B=Subordinate C=Customer E=Exec Comm M=Mentor P=Peer R=Supervisor S=Self Default Value: S |
| 3 | BID_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Worker Bids Accepted
Y/N Table Edit |
| 4 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 5 | EMPL_ORG_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Search Scope Record |
| 6 | ARCHIVE_DAYS | Number(4,0) | SMALLINT NOT NULL | Archive Days |
| 7 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 8 | STD_DAYS | Number(4,2) | DECIMAL(3,2) NOT NULL | Standard Number of Days/Week |
| 9 | TIME_START | Time(15) | TIMESTAMP NOT NULL |
Start Time
Default Value: 8:00:00AM |
| 10 | RS_ENABLE_WF | Character(1) | VARCHAR2(1) NOT NULL |
Enable Workflow
N=No Y=Yes Default Value: N |
| 11 | RS_HOL_HOURS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Holiday Hours From
C=Custom Settings Defined Here I=Standard Hours per Work Day J=Job Table Std Hours Default Value: J |
| 12 | HOLIDAY_HRS | Number(5,2) | DECIMAL(4,2) NOT NULL |
Holiday Hours
Default Value: 8 |
| 13 | SO_PRIORITY | Character(10) | VARCHAR2(10) NOT NULL |
Service Order Priority
Prompt Table: RS_PRIORITY_TBL |
| 14 | SESSION_ID | Number(6,0) | INTEGER NOT NULL | Session ID |
| 15 | FACTOR_ID | Character(3) | VARCHAR2(3) NOT NULL |
Factor ID
ACC=Accomplishments AVA=Availability PRO=Competency Proficiency YRS=Competency Years Of Experience Default Value: 000 |
| 16 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 18 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Default Value: MHR Prompt Table: UNITS_TBL |
| 19 | ORG_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 20 | ORG_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Organization Unit Record |
| 21 | SUN | Character(1) | VARCHAR2(1) NOT NULL |
Sunday
Y/N Table Edit Default Value: N |
| 22 | MON | Character(1) | VARCHAR2(1) NOT NULL |
Monday
Y/N Table Edit Default Value: Y |
| 23 | TUES | Character(1) | VARCHAR2(1) NOT NULL |
Tuesday
Y/N Table Edit Default Value: Y |
| 24 | WED | Character(1) | VARCHAR2(1) NOT NULL |
Wednesday
Y/N Table Edit Default Value: Y |
| 25 | THURS | Character(1) | VARCHAR2(1) NOT NULL |
Thursday
Y/N Table Edit Default Value: Y |
| 26 | FRI | Character(1) | VARCHAR2(1) NOT NULL |
Friday
Y/N Table Edit Default Value: Y |
| 27 | SAT | Character(1) | VARCHAR2(1) NOT NULL |
Saturday
Y/N Table Edit Default Value: N |
| 28 | ASSGN_ID_LAST_USED | Number(8,0) | INTEGER NOT NULL | Assignment ID Last Used |
| 29 | APPT_ID_LAST_USED | Number(8,0) | INTEGER NOT NULL | Appointment ID Last Used |
| 30 | RS_PROF_OBJECTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Objective
Y/N Table Edit Default Value: Y |
| 31 | RS_PROF_SPECIALTY | Character(1) | VARCHAR2(1) NOT NULL |
Areas of Specialty
Y/N Table Edit Default Value: Y |
| 32 | RS_PROF_WRK_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Work Experience
Y/N Table Edit Default Value: Y |
| 33 | RS_PROF_COMP_INT | Character(1) | VARCHAR2(1) NOT NULL |
Competencies & Interests
Y/N Table Edit Default Value: Y |
| 34 | RS_PROF_ACCOMP | Character(1) | VARCHAR2(1) NOT NULL |
Accomplishments
Y/N Table Edit Default Value: Y |
| 35 | RS_PROF_PREFS | Character(1) | VARCHAR2(1) NOT NULL |
Preferences
Y/N Table Edit Default Value: Y |
| 36 | RS_PROF_OTHER | Character(1) | VARCHAR2(1) NOT NULL |
Other (Flexible Attributes)
Y/N Table Edit Default Value: Y |
| 37 | RS_PROF_RES_ATTACH | Character(1) | VARCHAR2(1) NOT NULL |
Resume Attachment
Y/N Table Edit Default Value: Y |
| 38 | RS_PROF_PSPRT_VISA | Character(1) | VARCHAR2(1) NOT NULL |
Passports and Visas
Y/N Table Edit Default Value: Y |
| 39 | CALENDAR_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL |
Calendaring System Name
L=Lotus Notes O=Outlook |
| 40 | RS_CM_HRMS_INSTALL | Character(1) | VARCHAR2(1) NOT NULL |
Use to determine the source for employee and non-employee data.
1=PeopleSoft HCM 8.0+ 2=HCM 8.0+ and RS 3=PeopleSoft Resource Management Default Value: 1 |
| 41 | NON_EMPL_HR_RS | Character(1) | VARCHAR2(1) NOT NULL | Non-Employees in HR and/or RS |
| 42 | NON_EMPL_RS | Character(1) | VARCHAR2(1) NOT NULL | Empl and Non-Empl in Financial |
| 43 | NON_EMPL_STAFF | Character(1) | VARCHAR2(1) NOT NULL |
Non-Employees Staffable
Y/N Table Edit Default Value: N |
| 44 | DEFAULT_BU | Character(5) | VARCHAR2(5) NOT NULL |
Default Business Unit
Prompt Table: SP_BURSHR_NONVW |
| 45 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_NB_VW
|
| 46 | DEFAULT_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Default Location
Prompt Table:
LOCATION_TBL
|
| 47 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table: PERSONAL_DATA |
| 48 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 49 | DEFAULT_STD_HRS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 50 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Standard Work Period
Prompt Table: STDHRS_FREQ_VW |
| 51 | HOLIDAY_SCHEDULE | Character(6) | VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table: RS_HOLIDAY_TBL |
| 52 | RS_MANAGER | Character(1) | VARCHAR2(1) NOT NULL |
Update by Manager
N=N Y=Y Default Value: Y |
| 53 | RMO_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Optimization Mode
0=Optimization disabled 1=Solve enabled 2=Repair enabled Default Value: 0 |
| 54 | EXT_SO_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Enable External Search
Y/N Table Edit Default Value: N |
| 55 | EXT_REQ_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Requestor Defaults
Y/N Table Edit Default Value: N |
| 56 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 57 | LAST_ID_USED | Number(8,0) | INTEGER NOT NULL | Last Emplid Used |
| 58 | DEFAULT_ID_PREFIX | Character(3) | VARCHAR2(3) NOT NULL | Employee ID Prefix |
| 59 | VERITY_MODEL | Character(1) | VARCHAR2(1) NOT NULL | Model |
| 60 | RANKING_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL |
Ranking System
B=Both Score and Ranking R=Ranking S=Score |
| 61 | RMO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Resource Optimization
N=NO Y=YES Default Value: N |
| 62 | SO_AUTO_ID | Character(1) | VARCHAR2(1) NOT NULL |
Automatic Service Order ID
Y/N Table Edit Default Value: Y |
| 63 | SO_ID_LAST_USED | Number(8,0) | INTEGER NOT NULL | Last Service Order ID Used |
| 64 | GRR_ID_LAST_USED | Number(8,0) | INTEGER NOT NULL |
Last Generic Request ID
Default Value: 1 |
| 65 | LAST_POOL_ID | Character(10) | VARCHAR2(10) NOT NULL | Last Pool ID |
| 66 | STD_WRKDAY_MNTH | Number(2,0) | SMALLINT NOT NULL | Standard Work Days per Month |
| 67 | WRKDAY_FTR | Number(2,0) | SMALLINT NOT NULL | Work days to full time res |
| 68 | UOM_SCP | Character(1) | VARCHAR2(1) NOT NULL |
SCP - Demand Setup UOM
1=Days 2=Hours Default Value: 1 |
| 69 | SETID_REGION | Character(5) | VARCHAR2(5) NOT NULL |
Region SetID
Prompt Table: SP_SETID_NONVW |
| 70 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Task Category
Default Value: BE Prompt Table: RS_TASK_CAT |
| 71 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
RS_REGION
|
| 72 | SKIP_HOLIDAY | Character(1) | VARCHAR2(1) NOT NULL |
Skip Holiday On Assignment
Y/N Table Edit Default Value: Y |
| 73 | SKIP_INELGBL_DAYS | Character(1) | VARCHAR2(1) NOT NULL |
Skip Ineligible Days
Y/N Table Edit Default Value: Y |
| 74 | ENABLE_SEC1 | Character(1) | VARCHAR2(1) NOT NULL |
Enable Secure Data 1 Tab
Y/N Table Edit Default Value: N |
| 75 | ENABLE_SEC2 | Character(1) | VARCHAR2(1) NOT NULL |
Enable Secure Data 2 Tab
Y/N Table Edit Default Value: N |
| 76 | SEC_DATA1_NAME | Character(30) | VARCHAR2(30) NOT NULL | Secure Data 1 Tab Name : |
| 77 | SEC_DATA2_NAME | Character(30) | VARCHAR2(30) NOT NULL | Secure Data 2 Tab Name : |
| 78 | ADDRESS_SEC | Character(10) | VARCHAR2(10) NOT NULL | Address Security |
| 79 | SPECIALITY_SEC | Character(10) | VARCHAR2(10) NOT NULL | Area of Speciality Security |
| 80 | CITY_SEC | Character(10) | VARCHAR2(10) NOT NULL | City/Town Security |
| 81 | PHONE_SEC | Character(10) | VARCHAR2(10) NOT NULL | Home Phone Security |
| 82 | JOB_SEC | Character(10) | VARCHAR2(10) NOT NULL | Job Code Security |
| 83 | LICENSE_CERT_SEC | Character(10) | VARCHAR2(10) NOT NULL | License and Certification Sec |
| 84 | MOBILE_SEC | Character(10) | VARCHAR2(10) NOT NULL | Mobile Security |
| 85 | PSPRT_VISA_SEC | Character(10) | VARCHAR2(10) NOT NULL | Passport and Visa Security |
| 86 | POSTAL_SEC | Character(10) | VARCHAR2(10) NOT NULL | Postal Security |
| 87 | TEST_SEC | Character(10) | VARCHAR2(10) NOT NULL | Test Results Security |
| 88 | RS_UPD_SYNC | Character(1) | VARCHAR2(1) NOT NULL |
Update resources calendar synchronously with assignment update.
Default Value: Y |