6 Replies Latest reply: Jun 21, 2013 10:00 AM by Yacouba RSS

    OTL Timecard Status

    Avinash
      Hi All,

      If possible i need some quick update and suggestions on below points:-

      When we submit the timecard status changes to "Submitted" from WIP. And when manager approves the timecard status goes to "Approved" mode. Similarly when have many other statuses (Error, Rejected etc...). Now if we transfer the timecard to payroll (through BEE) what is the status of timecard? as far as I know it is still Approved.

      If there is no standard ststus for this scenarion (timecard transferred to BEE) we need to develope a query to know if the timecard has been transferred to BEE and will then use this query in custom form to show the status (Transferred to BEE).

      Please share your ideas and query.

      Thanks,
      Avinash
        • 1. Re: OTL Timecard Status
          Vigneswar Battu
          Hi Avinash,

          There is no specific status for the transferred card.
          There is a column transferred_to in the table hxc_timecard_summary which you can use.
          select transferred_to from hxc_timecard_summary
          where rownum < 3 ;
          Cheers,
          Vignesh
          • 2. Re: OTL Timecard Status
            Avinash
            Thanks Vignesh,

            But strangely I did not see this column in the table hxc_timecard_summary:-

            desc hxc_timecard_summary
            Name Null Type
            --------------------- -------- -------------
            TIMECARD_ID NOT NULL NUMBER
            TIMECARD_OVN NOT NULL NUMBER
            APPROVAL_STATUS NOT NULL VARCHAR2(30)
            RESOURCE_ID NOT NULL NUMBER
            START_TIME NOT NULL DATE
            STOP_TIME NOT NULL DATE
            RECORDED_HOURS NOT NULL NUMBER
            HAS_REASONS NOT NULL VARCHAR2(1)
            SUBMISSION_DATE DATE
            APPROVAL_ITEM_TYPE VARCHAR2(8)
            APPROVAL_PROCESS_NAME VARCHAR2(30)
            APPROVAL_ITEM_KEY VARCHAR2(240)
            ATTRIBUTE_CATEGORY VARCHAR2(30)
            ATTRIBUTE1 VARCHAR2(150)
            ATTRIBUTE2 VARCHAR2(150)
            ATTRIBUTE3 VARCHAR2(150)
            ATTRIBUTE4 VARCHAR2(150)
            ATTRIBUTE5 VARCHAR2(150)
            ATTRIBUTE6 VARCHAR2(150)
            ATTRIBUTE7 VARCHAR2(150)
            ATTRIBUTE8 VARCHAR2(150)
            ATTRIBUTE9 VARCHAR2(150)
            ATTRIBUTE10 VARCHAR2(150)
            ATTRIBUTE11 VARCHAR2(150)
            ATTRIBUTE12 VARCHAR2(150)
            ATTRIBUTE13 VARCHAR2(150)
            ATTRIBUTE14 VARCHAR2(150)
            ATTRIBUTE15 VARCHAR2(150)
            ATTRIBUTE16 VARCHAR2(150)
            ATTRIBUTE17 VARCHAR2(150)
            ATTRIBUTE18 VARCHAR2(150)
            ATTRIBUTE19 VARCHAR2(150)
            ATTRIBUTE20 VARCHAR2(150)
            ATTRIBUTE21 VARCHAR2(150)
            ATTRIBUTE22 VARCHAR2(150)
            ATTRIBUTE23 VARCHAR2(150)
            ATTRIBUTE24 VARCHAR2(150)
            ATTRIBUTE25 VARCHAR2(150)
            ATTRIBUTE26 VARCHAR2(150)
            ATTRIBUTE27 VARCHAR2(150)
            ATTRIBUTE28 VARCHAR2(150)
            ATTRIBUTE29 VARCHAR2(150)
            ATTRIBUTE30 VARCHAR2(150)
            TK_AUDIT_ITEM_TYPE VARCHAR2(8)
            TK_AUDIT_PROCESS_NAME VARCHAR2(30)
            TK_AUDIT_ITEM_KEY VARCHAR2(240)
            DATA_SET_ID NUMBER(15)
            ABSENCE_DAYS NUMBER
            ABSENCE_HOURS NUMBER


            If you have any idea could you please let me know what could be possible value of this column once timecard is transferred to BEE. I hope this column is linked with any LOV to contain list of valid entry. By any chance do you know the name of that LOV so that I can check the values from front end as I can not see it from backend.


            Thanks again for all your help.


            Thanks,
            Avinash
            • 3. Re: OTL Timecard Status
              Giuseppe Bonavita
              after the transfer of a tiecard to an external application you create another record at timecard level:

              select time_building_block_id
              ,resource_id
              ,start_time
              ,stop_time
              ,scope
              ,approval_status
              ,(select application_set_name from hxc_application_sets_v where application_set_id = h.application_set_id)
              from hxc_time_building_blocks h
              where scope in ('APPLICATION_PERIOD', 'TIMECARD')
              and date_to = '31-dec-4712'
              order by resource_id, start_time, scope desc, approval_status
              • 4. Re: OTL Timecard Status
                Vigneswar Battu
                Hi Avinash,

                What insstance are you working on ?

                we're on 12.1.3 -
                desc hxc_timecard_summary
                Name                  Null     Type          
                --------------------- -------- ------------- 
                TIMECARD_ID           NOT NULL NUMBER        
                TIMECARD_OVN          NOT NULL NUMBER        
                APPROVAL_STATUS       NOT NULL VARCHAR2(30)  
                RESOURCE_ID           NOT NULL NUMBER        
                START_TIME            NOT NULL DATE          
                STOP_TIME             NOT NULL DATE          
                RECORDED_HOURS        NOT NULL NUMBER        
                HAS_REASONS           NOT NULL VARCHAR2(1)   
                ..
                ..
                ..
                ABSENCE_DAYS                   NUMBER        
                ABSENCE_HOURS                  NUMBER        
                TRANSFERRED_TO                 VARCHAR2(240) 
                Alternatively, you can also use the solution provided by Giuseppe

                Also, please close the thread if you're done with it.. might help others..

                Satish,
                Are you not able to use any of the solutions provided above ?

                Cheers,
                Vignesh
                • 5. Re: OTL Timecard Status
                  603257
                  You could always check hxt_timecards_x and check whether the data has gone across?
                  • 6. Re: OTL Timecard Status
                    Yacouba

                    Sorry I'm new on HXC, but I have to edit business report on Timecard scoope. Can you give more about table and link on each other:

                    - HXC_TIMECARD_SUMMARY

                     

                    - HXC_TK_GROUP_QUERIES

                     

                    - HXC_TK_GROUP_QUERY_CRITERIA

                     

                    - HXC_TIME_BUILDING_BLOCKS

                     

                    Or give me link where a can find and understand easyly what I'm looking for...

                     

                    Thanks a lot...