Crew Effects (customized datagroup)

Owned by Daria Chebotaieva, created
Nov 06, 2023
2 min read
1 Description | 2 View Sample | 3 Main Data Selection | 4 SQL statement | 5 Columns Specification | 6 Start Page

Summary

The view shows the Crew Effects records stored in the customized datagroup for each crew member.

Keywords

Crew Effects, Customized

Category

Crew List View

Description

The view shows the Crew Effects records stored in the customized datagroup for each crew member.

View Sample

Main Data Selection

All crew members that have some record in the customized datagroup called Crew Effects (PW001U01).

SQL statement

CREATE VIEW dbo.PW001SRV138 as select CREF.PIN, P01.NAME, CREF.UFIELD1 [Date From], CREF.UFIELD2 [Date To], CREF.UFIELD22 [Vessel], CREF.UFIELD3 [TV], CREF.UFIELD4 [Stereo], CREF.UFIELD5 [Cellular Phone], CREF.UFIELD6 [MP3/IPOD], CREF.UFIELD7 [Electric Razor], CREF.UFIELd8 [Radio], CREF.UFIELD9 [Laptop], CREF.UFIELD10 [Tablet], CREF.UFIELD11 [Camera], CREF.UFIELD12 [Video Camera], CREF.UFIELD13 [Spirits], CREF.UFIELD14 [Cigrettes], CREF.UFIELD15 [Cigars], CREF.UFIELD16 [Perfume], CREF.UFIELD21 [Jewel], CREF.UFIELD17 [Sport Item], CREF.UFIELD18 [Musical Instrument], CREF.UFIELD19 [Video Games Consolle], CREF.UFIELD20 [Other], P01.CLIENT as NUMORGID, P01.EMPLOYMENTSTARTDATE, P01.EMPLOYMENTENDDATE from PW001U01 CREF left join PW001P01 P01 on P01.PIN=CREF.PIN

Columns Specification

Column

Description/ Location in APM

Column

Description/ Location in APM

PIN

Personal Details > Personal > PIN

NAME

Personal Details > Personal > Full Name

Date From

Crew Effects (PW001U01) datagroup - CREF.UFIELD1

Date To

Crew Effects (PW001U01) datagroup - CREF.UFIELD2

Vessel

Crew Effects (PW001U01) datagroup - CREF.UFIELD22

TV

Crew Effects (PW001U01) datagroup - CREF.UFIELD3

Stereo

Crew Effects (PW001U01) datagroup - CREF.UFIELD4

Cellular Phone

Crew Effects (PW001U01) datagroup - CREF.UFIELD5

MP3/IPOD

Crew Effects (PW001U01) datagroup - CREF.UFIELD6

Electric Razor

Crew Effects (PW001U01) datagroup - CREF.UFIELD7

Radio

Crew Effects (PW001U01) datagroup - CREF.UFIELD8

Laptop

Crew Effects (PW001U01) datagroup - CREF.UFIELD9

Tablet

Crew Effects (PW001U01) datagroup - CREF.UFIELD10

Camera

Crew Effects (PW001U01) datagroup - CREF.UFIELD11

Video Camera

Crew Effects (PW001U01) datagroup - CREF.UFIELD12

Spirits

Crew Effects (PW001U01) datagroup - CREF.UFIELD13

Cigrettes

Crew Effects (PW001U01) datagroup - CREF.UFIELD14

Cigars

Crew Effects (PW001U01) datagroup - CREF.UFIELD15

Perfume

Crew Effects (PW001U01) datagroup - CREF.UFIELD16

Jewel

Crew Effects (PW001U01) datagroup - CREF.UFIELD21

Sport Item

Crew Effects (PW001U01) datagroup - CREF.UFIELD17

Musical Instrument

Crew Effects (PW001U01) datagroup - CREF.UFIELD18

Video Games Consolle

Crew Effects (PW001U01) datagroup - CREF.UFIELD19

Other

Crew Effects (PW001U01) datagroup - CREF.UFIELD20

EmploymentStartDate

Personal Details > Employment > Employment Start Date

EmploymentEndDate

Personal Details > Employment > Employment End Date

Start Page

N/A